View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ledzepe
 
Posts: n/a
Default Conditional formatting


Hi everyone,

I have a spreadsheet that I monitor everyday. It contains 800 plus rows
of vehicle data. There is a column called "Safeties Due" which contains
dates that I need to change the background of the cell so that it the
due date is more 90 days, it stays green. If the due date is less than
90 days, its yellow and if the due date or pass due date, the
background is 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=488208