Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formula: time to expiration date becomes < 6 months | Excel Worksheet Functions | |||
Conditional Format for a date 1 month before Expiration in Excel 2 | Excel Worksheet Functions | |||
Retaining date formatting in referencing cell | Excel Discussion (Misc queries) | |||
Cell Referencing problem when copying conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formate:show by color when expiration dates are overdu | Excel Discussion (Misc queries) |