Color the minimum value in a row of data?

[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?

 

[jg70124]

Figured it out.

Formula is =b2=min(b2:f2) for row 2.

 

[Debra Dalgleish]

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

 

[Trevor Shuttleworth]

One way:

=AND(ISNUMBER(B2),MIN($B$2:$F$2)=B2)

Regards

Trevor