Well, thanks! That almost worked, but from what you gave me, I figured this
out and it works great:

=AND(ISBLANK(B1),(NOW()-31<A1))

Thanks for all your help!!!

- Ethan

"Mark Lincoln" wrote:

If the cell to be formatted is B1 and the date to compare to is A1,
then enter this formula in the Conditional Formatting dialog for B1:

=AND(ISBLANK(B1),(NOW()-A1)31)

Set the CF cell format to red, and you should be set. This will cause
B1 to turn red if it is blank and more than 31 days have passed from
the date in A1. Use the Format Painter to copy the format down as far
as you need.

Mark Lincoln

On Jun 22, 2:52 pm, NewGuy wrote:
Well, here's what I figured out, but it doesn't work. :(

=($A$1NOW())+("")

Any critiques?

- Ethan



"Gary''s Student" wrote:
Use Conditional Formatting (Formula Is):

If the cell is blank AND the current date exceeds the posted date by more
than 31 days, format the cell to RED
--
Gary''s Student - gsnu200732

"NewGuy" wrote:

I have a spreadsheet with all of our clients and the services we deliver to
each client. I have it all set up with dates, conditional formatting, IF
functions, point values, etc.

When we get a new client and add them to the spreadsheet, it adds cells for
all of the services that we WILL deliver to the client. If, after a certain
amount of time, depending on the service, the service is not delivered to the
client, it becomes overdue.

I want to see if there is a way to turn the cell red if no data has been
entered into the cell after a month (31 days).

Any suggestions?- Hide quoted text -

- Show quoted text -