Color the minimum value in a row of data?

  • Thread starter Thread starter jg70124
  • Start date Start date
J

jg70124

Excel XP

I am populating some data into cells B2:F2. I'd like the minimum value to
be colored red. I tried conditional formatting with this formula:
=MIN($B$2:$F$2) copied to all the cells, but it makes all the cells red.

Ideas?
 
Select cells B2:F2
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =B2=MIN($B2:$F2)
Click the Format button, and select formatting options
Click OK, click OK
 
Back
Top