Hep with Conditionals actions please.


M

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)
 
Ad

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top