P
prac g
in excel conditional formatting i want to find the greatest value in a column
and change its colour
and change its colour
B
Biff
Hi!
Suppose the numbers are in the range A1
5
Select the range A15
Goto Format>Conditional Formatting
Formula is: =A1=MAX($A$1:$D$5)
Click the Format button
Select the style(s) you want
OK out
Biff
Suppose the numbers are in the range A1
5Select the range A1
5Goto Format>Conditional Formatting
Formula is: =A1=MAX($A$1:$D$5)
Click the Format button
Select the style(s) you want
OK out
Biff