In the Conditional Formatting pane

Cell Value is: less than ="Today() - 31"

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