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