Thank you. It works great until I ran into one problem, when 0 is in the
equation it wont highlight anything. Is there a way to make it highlight
greater than zero?
TIA Again
Joe
"Joe Gieder" wrote:
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
|