Conditional format calculate 6 months

  • Thread starter Thread starter SoggyCashew
  • Start date Start date
S

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.
 
SoggyCashew said:
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.
Click to expand...

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
 
Worked like a charm... Thanks!
--
Thanks,
Chad


Victor Delta said:
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
Click to expand...
 
Back
Top