Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I am looking to create a fomula that changes a date in one column red and
bold when it falls within one calendar year of the current date. Can anyone provide a bit of guidance? Any help would surely be appreciated. Thanks in advance and have a great day. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Try,
Conditional formatting and try Formula is =$A1=DATE(YEAR(TODAY())+1,MONTH(TODAY()),DAY(TODA Y())) This will highlight days less than a year in the future. Mike "john mcmichael" wrote: I am looking to create a fomula that changes a date in one column red and bold when it falls within one calendar year of the current date. Can anyone provide a bit of guidance? Any help would surely be appreciated. Thanks in advance and have a great day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting for ddd hh:mm | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Please help with Conditional Formatting | Excel Discussion (Misc queries) |