ExcelBanter - Shading Cells based on Date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Shading Cells based on Date (https://www.excelbanter.com/excel-worksheet-functions/202889-shading-cells-based-date.html)

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!

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!