Hmmm...If the date in A1 is over 31 days ago, it turns the cell red, but any
date earlier than 31 days leaves it with no fill color.

Anyway, I'm having a problem with it still. The way the formula is written,
it will always reference that ONE cell. I have multiple clients I add and
need it to reference the cells for THOSE clients. Any suggestions?

"Mark Lincoln" wrote:

Ethan, in your original post, you wrote:

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).

This tells me that you wish the cell to turn red if it is blank after
31 days have passed. Your formula turns the blank cell red
immediately, and if it remains blank it will remain red until the day
after 31 days have passed, when it will revert to its normal
formatting.

However, if your formula works for you, it works for me! :)

Mark Lincoln

On Jun 22, 3:35 pm, NewGuy wrote:
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 -- Hide quoted text -

- Show quoted text -