Thread: [Solved] Conditional formatting
View Single Post
 
Old 03-02-2015, 04:35 PM
bbutl027 bbutl027 is offline Windows 8 Office 2013
Novice
 
Join Date: Mar 2015
Posts: 17
bbutl027 is on a distinguished road
Exclamation Conditional formatting

I have been reading thread all day and trying different ones to see if they work for what I need, no luck.

OK, each cell will have a different date. I need the cells to automatically change colors when they reach one of the parameters.

<90 days from the date's annual date will turn yellow
<60 days from the date's annual date will turn amber
<30-past due from the date's annual date will turn red
>91 days it will remain green

Please let me know if you need more information
Reply With Quote