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: 9
Default Conditional formatting referencing date of expiration

I'm trying to apply conditional formatting to a cell, to show it has expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however the
conditional formatting changes immediately even though the two cells are not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should apply.

 
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 formula: time to expiration date becomes < 6 months Susan Excel Worksheet Functions 2 April 30th 08 12:40 AM
Conditional Format for a date 1 month before Expiration in Excel 2 JonMAd Excel Worksheet Functions 2 August 28th 07 05:14 AM
Retaining date formatting in referencing cell Corey Foote Excel Discussion (Misc queries) 2 August 22nd 07 03:34 PM
Cell Referencing problem when copying conditional formatting Sarah (OGI) Excel Discussion (Misc queries) 0 April 19th 07 04:54 PM
Conditional formate:show by color when expiration dates are overdu dan Excel Discussion (Misc queries) 0 August 24th 06 10:27 PM


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