Click on A3
Format, Conditional formatting, Formula is: '=A3 = MIN($A$3:$D$3)'
{without the single quotes)
Select your formatting options, OK
Copy cell A3
Paste special, formats over the rest of the range.
HTH
Steve
"Joe Gieder" wrote in message
...
I'm trying to highlight the cell with the lowest value by using
Conditional
Format.
Example..
A3 = 4
b3 = 7
c3 = 3
d3 = 10
I want to highlight C3 but I tried
=MIN(K$3,$BN$3,$BQ$3,$BT$3) in the Formula Is part of Conditional
Formating
and it highlights all the values. Can This be done.
TIA Again
Joe
|