Another Date Conditional Format

[pjrweb]

Evening,

I am struggling to find this type of formatting.

I enter a date when a person took a test e.g. 29/AUG/11

If 275 days i want it to go Amber and in 365 days go red.

Any help on the code?

Regards,
PJ

 

[cstimart]

Evening,

I am struggling to find this type of formatting.

I enter a date when a person took a test e.g. 29/AUG/11

If 275 days i want it to go Amber and in 365 days go red.

Any help on the code?

Regards,
PJ

Not sure you need any code, have you tried Conditional Formatting on the appropriate cells?

 

[pjrweb]

I can't work out the formula to do it.

 

[VoG]

With the test date in A1, for the 275 day case try

=TODAY()-A1>275

 

[pedro-egoli]

I have been trying to get conditional formatting working and have been using dates 275 and 365 before 29/8/11 as the start date .
I can get the first condition to work with a simple "=27/10/10+275" . However, when I enter 2nd condition as '=29/8/10+365" I am unable to test that condition without deleting the first .
I am beginning to think that when the 275 days event occurs the condition attaching will need to be cancelled and a fresh one to cover the 365 days entered.
Have a feeling the same would need to be done with Vog's suggestion .

Pedro

 

[cstimart]

What version of Excel are you using?

 

[pedro-egoli]

version 2003


Pedro

 

[cstimart]

version 2003


Pedro

Trying changing the order of the conditions.

 

[pedro-egoli]

Changed the order and condition 1 (now red) remains.

I take it you have been successful with your test?What did you use as parameters?

Pedro

 

[cstimart]

For my first rule, I have..

=TODAY()-A1>365

for the second rule, I have..

=TODAY()-A1>275


therefore, if the date is > 365 it turns red and if it's > 275 it turns amber if <= 275 is doesn't change.