| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Condition Formatting - Dates
what is the formula to use to change the color of dates in a column ? I am
using conditional formatting. I have =today()+7 but that is not working. Any suggestions? Thank you very much! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2007 Condition Formatting - Dates
Select the range of cells. Say Column A
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: (if date is exactly same as today + 7) =A1=TODAY()+7 (if greater than one week) =A1=TODAY()+7 Click the Format button Select the desired style(s) OK out If this post helps click Yes --------------- Jacob Skaria "Miskacee" wrote: what is the formula to use to change the color of dates in a column ? I am using conditional formatting. I have =today()+7 but that is not working. Any suggestions? Thank you very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: Can it SUMIF( ) using color as a condition ? | Excel Discussion (Misc queries) | |||
| sumif across multiple sheets in excel 2007 based on a condition | Excel Worksheet Functions | |||
| Conditional formatting of dates in two cells using Excel 2007 | Excel Worksheet Functions | |||
| Conditional formatting dates in 2007 | Excel Worksheet Functions | |||
| I need 4 condition for condition formatting | Excel Programming | |||
Linear Mode
