Conditional format calculate 6 months

[SoggyCashew]

Hello, I cant figure out how to do this. I have a date in a cell, lets say
its 10/5/9 and I want that box to stay red untill 6 months have past. so when
its 4/6/10 then the box wont be red anymore.

 

[Victor Delta]

Hello, I cant figure out how to do this. I have a date in a cell, lets say
its 10/5/9 and I want that box to stay red untill 6 months have past. so
when
its 4/6/10 then the box wont be red anymore.

Use conditional formatting with the formula Cell value is between '=today()'
and '=today()-182', and set the format pattern as red. You may want to vary
the exact number of day used - 182 is approximately 6 months.

V

 

[SoggyCashew]

Worked like a charm... Thanks!
--
Thanks,
Chad

Use conditional formatting with the formula Cell value is between '=today()'
and '=today()-182', and set the format pattern as red. You may want to vary
the exact number of day used - 182 is approximately 6 months.

V