C
ChristinaC
I am trying to generate the following scenario:
1. If a cell is blank, colour blue
2. If a cell whose inserted date is less than or equal to the date in
another cell, colour green
3. If a cell whose inserted date is greater than the date in another cell,
colour orange.
4. If NA is put in this cell revert back to no formatting at all.
I have got the first three easily by:
1. =$H14=0
2. =$H14>$G14
3. =$H14<=$G14
but what I cannot seem to do is amend the formula to get it to revert back
to white if NA is put in H14. Is there a way of doing this without using VB?
1. If a cell is blank, colour blue
2. If a cell whose inserted date is less than or equal to the date in
another cell, colour green
3. If a cell whose inserted date is greater than the date in another cell,
colour orange.
4. If NA is put in this cell revert back to no formatting at all.
I have got the first three easily by:
1. =$H14=0
2. =$H14>$G14
3. =$H14<=$G14
but what I cannot seem to do is amend the formula to get it to revert back
to white if NA is put in H14. Is there a way of doing this without using VB?