Conditional Formatting w/ Dates

  • Thread starter Thread starter John F.M.
  • Start date Start date
J

John F.M.

I would like to format a set of cells on a condition using dates. For
example, in cell A1 I have 5/23/05. In cell B1 I have 6/19/05. In cell
C1 I want to have the condition dependent upon the difference of cells
A1 and B1. How do I subtract the dates to give me the condition I am
looking for. Let us say the conditions are: less than 7 days is green;
greater than 7 days, less than 14 is orange; greater than 14 days is
red.
 
Assumption: you will be copying this CF down column C, referring to
columns A and B as in the original formatting.... That is, A2 and B2 to
calculate C2, etc.

First, you will need to edit your formulas in the Conditional Format in
C1 to remove any fixed references (i.e. '$') so that =$B$1-$A$1<=7
becomes =B1-A1<=7 and so on...

then simply copy this cell, select your desired range (C2:C200?) and
Paste Special>Formats

Good Luck
 
Back
Top