Posted: 1/24/2007 12:05:57 PM EDT
I'm out on a job site at the moment and it seems everyone back at the office is either gone home for the day, traveling to a destination or in a meeting...so I'm coming to you guys. How the hell do I use Conditional formatting in Excell to make a cell turn yellow 2 days before a certain date and red on that certain date. Example: (Assume starting cell is A1) A 1:Action Required! 2:1/26/07 I've tried the Conditional formatting of =AND(A1>0,A1+2<=TODAY()) ...and it does nothing for me. |
|
Hopefully it's not too late but I think I figured out a way to do it (it works): Under format go to conditional formatting. You will need 2 conditions Formula is =IF(TODAY()=$A$2-2 , $A$2) this is your yellow click add and input in second box Formula is =IF(TODAY()=$A$2 , $A$2) this is your red |