Conditional Formmating Help

S

steven.britton

I have a row of 5 numbers -

I want to highlight the lowest number in the row using conditional
formatting

Help out there?

-Steve
 
B

Bob Umlas

If A1:E1 are selected:
=A1=MIN($A1:$E1)
is the formula to use in the conditional formatting dialog...
Adjust accordingly
Bob Umlas
Excel MVP
 
Top