| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format calculate 6 months
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. -- Thanks, Chad |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format calculate 6 months
"SoggyCashew" wrote in message
... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format calculate 6 months
Worked like a charm... Thanks!
-- Thanks, Chad "Victor Delta" wrote: "SoggyCashew" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate # of months if a date is given | Excel Discussion (Misc queries) | |||
| calculate number of months | Excel Discussion (Misc queries) | |||
| Calculate Age in Years and Months? | New Users to Excel | |||
| Calculate 6 Months | Excel Discussion (Misc queries) | |||
| Calculate months and years | Excel Discussion (Misc queries) | |||
Linear Mode
