Hi,
I conduct audits annually and want to highlight upcoming audit dates that I need to begin working on scheduling. I am working with the last audit date and need 4 months notice. I have tried to setup conditional formatting but get everything but what I want.

Column E lists the last audit date:
8/10/11 (needs to highlight)
5/26/11 (needs to highlight)
4/6/12
11/2/11

Can anyone help??
Thanks! Laurie