Conditional Formatting

P

picktr

I'm not sure what "formula is" should be
in the conditional formatting.

I need to have a cell change color
if, compared to a range of cells, its value
is = to or the lowest within that range,
not including 0.

thanks,

To
 
D

Debra Dalgleish

If cell G4 is the cell in which conditional formatting is being applied,
and the comparison range is A1:E9, the formula is:

=G4<=MIN(IF($A$1:$E$9>0,$A$1:$E$9))
 
J

jyang

Highlight the cells or range you wish to evaluate. Then
click on the format menu, scroll down to conditional
formating. Select which condition you would like...such
as "cell value is equal to..", then select the cell you
wish to compare the range to. Next click on the format
button. You can choose to change the font style, cell
border, or the cell pattern...which ever one you would
like. In your case, since you want the whole cell to
change color...you would select the patterns tab, and
choose your desire color. Click ok, and you should be
done.

jyang
 
Top