Highlight the lesser value

[pdizzy]

Hi

If A1 = £3.59 and B1 = £3.60 and C1 = £3.32 what formula or conditional format do I need to have the lesser value (in this case C1) to be highlighted?

The values change as you go down the worksheet and on line B it could be B2 which has the lesser value.

Thanks

 

[VoG]

Hi. Select A1:C1 then use the CF formula

=A1=MIN($A1:$C1)

 

[pdizzy]

Hi

Thanks, that works on one line but how do I get it to continue the format all down the sheet?

Thanks

 

[VoG]

Select A:C from row 1 all the way down then use the same CF formula.