View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spaceace Spaceace is offline
external usenet poster
 
Posts: 1
Default Cell colour change.

Please help.
I have 3 cells next to each other on a spread sheet. First cell has an order
date the second cell has a delivery date. I want the third cell to display a
differant colour when the todays date gets within a set amount of days of the
delivery date. Like a status cell. E.g Goes green within a week of the
date/goes red within 2 days of the delivery date.
please please help me.....