=AND(B1<"",B1=TODAY(),B1<=TODAY()+30)

should do the first

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Diane1477" wrote in message
...
I have two columns of data:
Column A (Current Review Date) Column B (Next Review Date (2 years out)
I want to conditionally format so that the reviews due within 30 days of
today are highlighted and the reviews overdue are also highlighted but
that
cells containing no date remain unchanged. I have tried multiple
variations
of the Today +30 and the =AND(B1<"",B1<TODAY()) formulas with no
success.
SEE BELOW:
Example Data:
Column A Column B
1. 9/1/05 9/1/07 (This would appear in RED)
2. 10/1/05 10/1/07 (This would appear in GREEN)
3. blank blank (This would be unaffected by the conditional
format)
4. 1/5/06 1/5/08

PLEASE HELP!