How to create Conditional Formatting with a range of dates?

Hi,

first of all, I'm glad this forum is back (or was it just me?) - I could not access the site for about 2 weeks and felt really bad for losing such a great resource.

Anyway, I'm glad this works again.

A question: I have a list of dates which I'd like to highlight with conditional formatting. I'd like to highlight a date that is within two days (plus or minus) from the current/present day.

I tried using "IF" statement in the formula part of Conditional Formatting but somehow I couldn't get it to work.

I'm attaching a file with more explanation. I hope someone like Carim can help again...

Thanks and best regards.

Hi Carim,

thank you, this is exactly what I wanted to achieve. So, it's AND and not IF! See? That's why I come to this forum.

So, what happened? Is it going to happen again? Is there any other place to go in case this website implodes?

Thank you again!