If you need to Highlight the Maximum in each row for column B,K and P
Also for the Minimum in each row for column B,K and P
1- Select column B
2- Conditional Formatting, New Rule
3- Click on Use a formula to determine which cells to format
4- In the box under Format values where this formula is True
5- Write =B2=MAX(B2,K2,P2)
6- Choose the format you want
Repeat the same for Minimum:
1- Select column B
2- Conditional Formatting, New Rule
3- Click on Use a formula to determine which cells to format
4- In the box under Format values where this formula is True
5- Write =B2=MIN(B2,K2,P2)
6- Choose the format you want
For column K:
1- Select column K
2- Conditional Formatting, New Rule
3- Click on Use a formula to determine which cells to format
4- In the box under Format values where this formula is True
5- Write =K2=MAX(B2,K2,P2)
6- Choose the format you want
For Minimum:
1- Select column K
2- Conditional Formatting, New Rule
3- Click on Use a formula to determine which cells to format
4- In the box under Format values where this formula is True
5- Write =K2=MIN(B2,K2,P2)
6- Choose the format you want
For column P:
1- Select column P
2- Conditional Formatting, New Rule
3- Click on Use a formula to determine which cells to format
4- In the box under Format values where this formula is True
5- Write =P2=MAX(B2,K2,P2)
6- Choose the format you want
For Minimum:
1- Select column P
2- Conditional Formatting, New Rule
3- Click on Use a formula to determine which cells to format
4- In the box under Format values where this formula is True
5- Write =P2=MIN(B2,K2,P2)
6- Choose the format you want
Just don't use $ in your formula specially for rows
If you don't need the whole column, you can use Format Painter
for each cell in the same column (for example B2, B5, B10 select B2 after applying the conditional formatting, click on Format Painter
and select B5)
Format Painter
can copy the conditional formatting
The same for P2, P5 you have to select P2 after applying the conditional formatting, click Format Painter and select P5