View Single Post
  #1   Report Post  
raven_guy
 
Posts: n/a
Default How do I make it change colour

I am tracking dates in excel... basically as follows... Start date to
completed date... I am looking into how to make a cell change colour after a
certain amount have days have passed?

example: (a1= June 1st 2005 a2= completed date )after 5 days from start
date.. change the completed date cell red.

Thanks
Ron