Formula for Conditional Formating - Help!
Try:
=AND(ISBLANK($A$4), ISNUMBER($A$5), $A$5TODAY())
You can paste the formula using Ctrl+V. The right click popup menu isn't
available when the Conditional Format dialog is open.
Regards,
Greg
"Mark Campbell" wrote:
I am trying to enter a fromula using the conditional formating menu -
I wish to highlight the contents of cell A2 if and only if both the
following conditions are true
cell A4 = blank
cell A5 - contains a date which is greater than today.
Any help appreciated - I can insert 2 seperate formula for this but i want
both conditions to apply before the formating is applied.
Thanks in advance
|