View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SR7133
 
Posts: n/a
Default Change cell Colour when a number of days have been passed

I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following:

I will be entering dates in a column and then between 1 and 7 days an
adjacent cell will show green and the words "Processing"

Between 8 days and 14 days the adjacent cell should turn yellow and show
"Check Status"

If the period exceeds 14days then the cell should turn red and show the word
"Overdue"

I have tried a number of the responses in the threads but just cannot seem
to get the proper result.

Thanks in advance