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.

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.