Conditonal Formatting
 

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?

Conditonal Formatting
 

No.

--
__________________________________
HTH

Bob

"Eán" wrote in message
...
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?

Conditonal Formatting
 

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.
--
David Biddulph

"Eán" wrote in message
...
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?