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?