View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rhatala@stny.rr.com is offline
external usenet poster
 
Posts: 10
Default Conditional Formating planned VS actual date

Windows XP SP2, MS Excel 2003.

I have a project plan that has target and actual date columns.
Format is 03/02/05.

Would like to highlight the planned date cell if it is within 2 days
of todays date in yellow AND the actual date cell is blank.

If the Actual date is filled in, then no formating of the Planned date
cell.

If the planned date is = or than today and the actual date field is
blank, format the planned date cell RED.

Any help would be greatly appreciated

Thank you