Hep with Conditionals actions please.

[Mark]

Using Conditionals

In O7
=AND(O7<>"",O7<=0) Green
=AND(O7<>"",O7>=1) Red


If I delete the date in O5 above, this conditionaL. The cell O7 remains on
it's last color, Red or green, it does not revert to white.

It will with $, but then I can't copy 800 rows.

Is there a an answer?

I would like O7 to revert to white if O5 has it's date removed. And have the
same type conditionals.

Thank you.

(Of course or figure how to copy $ down 800 lines and have the cell #'s
change accordingly)

 

[Alojz]

hi, u have to add the conditions for the event when the cell is blank, try
this set of conditions:
=and(o7<=0;not(isblank(o7))) Green
=o7>0 Red
=isblank(o7) Blank

I comare the value with 0 in first 2 conditions so not to omit the situation
when value falls between 0 and 1.
adopt to ur need and click yes if this was helpful

 

[David Biddulph]

Why not include an O5 test in your conditions?

=AND(O5<>"",O7<>"",O7<=0) Green
=AND(O5<>"",O7<>"",O7>=1) Red