| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of a cell
put a date in d1 and then create the conditional formatting formula and
criteria and see if it does what you want. =(today())DATE(YEAR(D1),MONTH(D1) +15,DAY(D1)) -- Gary Keramidas Excel 2003 "Lou825" wrote in message ... I have Excel 2003 and I am having a problem with conditional formatting. I have a sheet that I put dates in cells and need the cell to change color when its 15 months from todays date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Threaded Mode
