Try this formula...

=IF(ABS(D1-1.5-TODAY())<=1.5, "CALL CLIENT!","")

and use my

=E1<""

Conditional Format formula in the "Formula Is" field.

--
Rick (MVP - Excel)


"Studebaker" wrote in message
...
I'm sorry but it is not working. The cell doesn't do anything. Do you
think
the <=(D1-3) part is correct? B/c I want to say if today is 3, 2, or 1
days
before the expiration date or on the expiration date then say "Call
Client".
Can you think of anything?

Thanks for the reply.


"Sheeloo" wrote:

Put this in E1
=IF(TODAY()<=(D1-3), "CALL CLIENT!","")

then use this in FORMULA IS for conditional formatting for cell E1
=TODAY()<=(D1-3)

You can then paint this on other cells in Col E

If you want to compare all cells in E with D1 then change D1 to $D$1...

--
--------
If this is what you wanted then press the ''''YES'''' button (if you see
it)


"Studebaker" wrote:

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