View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas[_2_] Bob Umlas[_2_] is offline
external usenet poster
 
Posts: 68
Default Conditional Formmating Help

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

" wrote in message
...
I have a row of 5 numbers -

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

Help out there?

-Steve