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!