Excel CF help

[Jagdev]

Excel CF help
Could you please help me with the CF formula which will change the color of the cell whenever the date is changed to 7 days after the applied date?
Say in the attached sample the date in column A is 17^th March and it will be fixed throughout the column A. In case if someone changes the date to 25^th March or above, it should change the cell color. Till the date 24^th it should not change it color and from 25^th and above change the color of the cell
Regards,
JD

[Kenneth Hobs]

Try using a formula that results in a boolean, true or false, value for A2 in some other cell. Copy the formula down and you should get True and False. Now add the relative addressed formula for A2 in the conditional format of A2.

e.g.
Choose the last option of Conditional Formating for a formula in A2 as:
=A2>DATE(2015,3,17)+7
Set the format for when that is true to implement.

I generally do that for one cell, copy it, and the use the Formatting option in Paste Special to format the other cells the same. The key is using absolute or relative cell addressing to suit.

[Jagdev]

Hi Kenneth

Thanks for the formula. It really worked!

Regards,
JD

[Aussiebear]

SinceK Kenneth has provided a solution, would you mind going to the Thread tools dropdown and marking the solution as solved?

[Jagdev]

Hi Aussie

Sorry for missing this out.

Regards,
JD