Hello,
I'm having trouble setting up conditional formatting rules in excel 2010.
I have a column of dates with changing values.
I need the dates to be default green when they are far off, change to orange when they are in the next 60 days and be red when they are past.
I thought it would be simple but I can't do it with the pre-set rules in this version.
Is there a formula I can use to set these groups up, possibly using the TODAY() function?
Thanks![]()
Bookmarks