View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Campbell Mark Campbell is offline
external usenet poster
 
Posts: 16
Default Formula for Conditional Formating - Help!

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