| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculation & Conditional Formatting
Hi, I am trying to use conditional formatting to color/highlight a cell but
am stumped. Cell G2 has a date: 18 Jun 08 I need the cell to be colored/highlighted when 1 year has passed. SO, when the spreadsheet is opened today on 7 Aug 09, the conditional formatting sees that more than 1 year has passed since the date in cell G2 so teh cell is highlighted. How can I do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| conditional formatting a date | Excel Discussion (Misc queries) | |||
| Date Calculation in Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Formatting Date | New Users to Excel | |||
| Conditional formatting of date | Excel Discussion (Misc queries) | |||
Threaded Mode
