| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculation & Conditional Formatting
1. Select the cell G2
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =AND(G20,DATE(YEAR(G2)+1,MONTH(G2),DAY(G2))<TODAY ()) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Stumped" wrote: 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
