LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Conditional Formatting with Dates

Hi,

I have a spreatsheet in Excel 2003. It is used to track Purchase Orders.

Column F is the Date the items are needed to arrive. I would like a
conditional Format that would change the cell with the arrival date to Red if
the Item is within 2 workdays of the date that is in the cell.

Example: If the date in the cell is 6 Mar, and today is 4 Mar, I would like
the cell to turn Red.

Any help would be appreciated.
 
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 formatting - Dates Duncan Excel Discussion (Misc queries) 2 July 23rd 07 10:50 PM
Conditional Formatting for dates Richhall Excel Worksheet Functions 2 March 23rd 07 02:38 PM
Help with Conditional Formatting (Dates) BigH Excel Discussion (Misc queries) 1 January 28th 06 10:47 PM
conditional formatting dates Phil Excel Discussion (Misc queries) 6 July 24th 05 09:18 PM
Help with Conditional formatting with Dates Prabha Excel Discussion (Misc queries) 4 February 14th 05 04:13 PM


All times are GMT +1. The time now is 08:12 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"