Why not include an O5 test in your conditions?

=AND(O5<"",O7<"",O7<=0) Green
=AND(O5<"",O7<"",O7=1) Red
--
David Biddulph

Mark wrote:
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)