condtional format - hightlight max results
I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value
Use the above but change the formula to:
=L4=max($L$4:$L$20)
--
Biff
Microsoft Excel MVP
"Nadine" wrote in message
...
Have 3 columns, L M N which display percentage results based on values
entered in other columns (cells in columns contain count formulas)
In these columns I want the max result to highlight in different color
I tried
cell value is - equal to - =max(L4:L20)
but does nothing
I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value
|