LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating For a Date Dan Excel Discussion (Misc queries) 3 January 30th 09 06:35 PM
More Planned and Actual Cycle Times PAL Excel Worksheet Functions 5 January 17th 08 08:35 PM
how do I do a Planned vs Actual start date & end date graph chivy76 Charts and Charting in Excel 0 September 26th 05 07:47 AM
how do I do a Planned vs Actual start date & end date graph chivy76 Charts and Charting in Excel 0 September 26th 05 07:47 AM
Conditional formating w/ Date Steven Stadelhofer Excel Worksheet Functions 1 February 3rd 05 05:29 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"