Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to create conditional format linked to date
I wish to create a conditional format linked to date, for example if info. in
cell is less than 2 months old, the cell is green, if info. is more than 2 months old the cell turns red. |
#2
|
|||
|
|||
one way:
Format the cell to green. The FormatConditional Formatingchange cell is to formula is =if(today()-60=a1,true,false) and set the format to red HTH "nicko68" wrote: I wish to create a conditional format linked to date, for example if info. in cell is less than 2 months old, the cell is green, if info. is more than 2 months old the cell turns red. |
#3
|
|||
|
|||
I don't believe it's possible to do exactly what you're asking. I don't
think excel stores the date a cell was last modified. You can however use conditional formating with dates that you input. Highlight the dates and select format-condition formatting. select "formula is" and type... =MONTH(TODAY())-MONTH(A1)2 with A1 being the cell in the top left of your selection. Click on format and choose red as the background color. Add a new format and type.. =MONTH(TODAY())-MONTH(A1)<2 Click on format and choose green as the background color. I know this isn't exactly what you want, but I hope it helps. "nicko68" wrote: I wish to create a conditional format linked to date, for example if info. in cell is less than 2 months old, the cell is green, if info. is more than 2 months old the cell turns red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create conditional IF to format cells using 6 different colours | Excel Worksheet Functions | |||
DATE Format | Excel Worksheet Functions | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Date Format - Conversion | Excel Discussion (Misc queries) | |||
format the "date" button for a header | Excel Discussion (Misc queries) |