Forum Discussion
Rule that colours highest value and lowest value
Let's say you have prices in C2:K100.
Select this range. I will assume that C2 is the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=C2=MIN($C2:$K2)
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.Repeat these steps, but with the formula =C2=MAX($C2:$K2) and red as color.
Let's say you have prices in C2:K100.
Select this range. I will assume that C2 is the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=C2=MIN($C2:$K2)
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.
Repeat these steps, but with the formula =C2=MAX($C2:$K2) and red as color.