Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try,

Conditional formatting and try Formula is

=$A1>=DATE(YEAR(TODAY())+1,MONTH(TODAY()),DAY(TODAY()))

This will highlight days less than a year in the future.

Mike
 
Back
Top