Conditonal Formatting

E

Eán

I have the formula is : =IF(F9-1<=$E$6+3,1) to turn my conditionally
formatted cell red, but I want to also have the number 1 for red in there, is
there anyway I can do that?
 
D

David Biddulph

See your other post.
Note that in your formula in CF's "Formula Is" you don't need the
=IF(...,1).
The formula in CF is =(F9-1<=$E$6+3), or simplify it to =(F9<=$E$6+4)
or =(F9-4<=$E$6)

You can put the =IF(...,1) formula in the cell (as distinct from in CF) if
you want want the cell contents to be 1.
 
Top