Hello,

I'm having trouble with a formula in conditional formatting.

Column D has an expiration date (date a pledge expires) and Column E will be
blank, but Column E will be where I want my conditional formatting. I want
Column E to say in bold, red letters, CALL CLIENT!, when today's date is less
than or equal to 3 days before the expiration date in Column D.

The conditional formula I had in Column E was FORMULA IS:
=IF((TODAY()<=$D$1)-3, "CALL CLIENT!") and then I had it format the font to
be bold, red if statement is true. This doesn't work. Can someone help?

Thank you very much!
Studebaker