I need to have certain cells change color at a specific time. I enter a
date in a cell, say 30 days from today's date. Starting 10 days from today's
date till tomorrow, I need the cell to change to Yellow. From today & beyond
I need the cell to change to Red. Is this possible? I have over 250 cells
with dates and it would be much easier if the dates getting close to today's
date were highlighted. I would appreciate any and all help on this.
Thanks
Dennis
glen.e.mettler@lmco.com - 28 Mar 2006 18:56 GMT
Condition1
Formula - =A1<=TODAY()
Condition2
Formula - =(A1-TODAY())<10
Glen
sampson@yahoo.com - 29 Mar 2006 02:33 GMT
Glen
Your formula worked perfectly.
Thanks again
Dennis