| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shading Cells based on Date
I am trying to shade cells in a row which meet the criteria of the date being
300 days old. I am using Excel 2007 and have tried utilizing conditional formats but am running into problems. The preset rules for dates to not allow enough flexibility to change what I need to (I think), and trying to manipulate other formulas I found via help (I thought Now()-360 would work) has been dissappointing. So, if I have a row of 70 cells in which I want to highlight any dates 1 year old, how do I go about it? Sounds like I need to use conditional formats, but for some reason the formulas aren't as straight forward as I thought they were when I read them. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shading Cells based on Date
Conditional Formatting
=TODAY()-EDATE($A1,12)0 "Lee Quillen" wrote: I am trying to shade cells in a row which meet the criteria of the date being 300 days old. I am using Excel 2007 and have tried utilizing conditional formats but am running into problems. The preset rules for dates to not allow enough flexibility to change what I need to (I think), and trying to manipulate other formulas I found via help (I thought Now()-360 would work) has been dissappointing. So, if I have a row of 70 cells in which I want to highlight any dates 1 year old, how do I go about it? Sounds like I need to use conditional formats, but for some reason the formulas aren't as straight forward as I thought they were when I read them. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
| Apply cell shading based on adjacent cells in EXCEL | Excel Worksheet Functions | |||
Linear Mode
