Hi all,

I have a worksheet that have a column for "Safeties Due Date" and I
have about 800 rows to monitor. I can't sort them because of many
reason so I thought that if I can have the background color change then
I can tell from a glance which rows needs to have their Safeties. Here
some additional info:
more than 90 days from due date, background in green
less than 90 days from due date, background in yellow
due date or pass the due date, background in red

Is this possible?


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=487991

Hi,
Yes it is. In conditional formatting use these formulas:
condition 1. select "formula is:" and:
=A1-TODAY()=90
conditon 2. select "formula is:" and:
=A1-TODAY()0
condition 3. select "formula is:" and:
=A1-TODAY()<=0

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=487991