Ok, new problem:

None of the new cells are referenced to a cell with a date, say the date the
client was added.

My macro currently inserts a row and formats the appropriate cells. I can
easily modify it so it puts the date the client is added into a cell, but if
I set the above conditional formatting into my macro, it only references it
to a set cell. Does that make sense?

I'm caving in on myself here.... :(

"Pops Jackson" wrote:

Ignore my previous reply. It does not work.
--
Pops Jackson


"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?