using conditional formatting

[Green1972]

Hello.
Ok what i have is a range of cells containing different dates (row E100 to BB100). In cell B20 i have another date. What i want to do is use conditional formatting to highlight the cells in row E100 to BB100 that are within 7 days of the date in cell B20. Is it even possibel.

 

[T. Valko]

Thank you. i have tried it and it works well. thank you for showing me that

You're welcome. Thanks for the feedback!

 

[cummingsea]

Hi. I tried your formula (T Valko) but it didn;t work any other ideas.

Bump

 

[T. Valko]

Bump

Why the "bump"?

The OP has since replied back and their query has been answered to their satisfaction.

Originally Posted by Green1972
Thank you. i have tried it and it works well. thank you for showing me that