Different colour date question

[Orangeanorak]

cell B4 holds the current date =today()

cell B5 holds a date in the future

Can you give me a formula which changes B5 to yellow when it is the same date as B4 and remain that colour for 5 days only

Thank you for your time

 

[njimack]

What do you mean by "remain that colour for 5 days only"?
Mabye: =AND(B5>=B4,B5<=B4+5)

 

[Orangeanorak]

I will try that thanks

What i mean is if current date in B4 is 6th March 2011

I want B5 to change to yellow on 6th March 2011 and stay yellow until 10th March 2011

 

[Orangeanorak]

What do you mean by "remain that colour for 5 days only"?
Mabye: =AND(B5>=B4,B5<=B4+5)

Will that work if B4 date changes to the current date each day

 

[njimack]

Will that work if B4 date changes to the current date each day

Nope. If you don't want the conditional formatting linking to a volatile cell, you'll need a separate cell that you manually input the date into.