Changing the format of a cell after a time limit
Since the cell was created. I have a list of all our clients and the specific
services that we deliver to that client.
When we get a new client, some services are not delivered right away and if
they are not delivered after a certain amount of time, let's say 30 days,
then it's overdue and I want to turn those cells red.
"Vasant Nanavati" wrote:
After a certain amount of time since when?
__________________________________________________ ___________________
"NewGuy" wrote in message
...
Hello, Everyone!
I am trying to find out if there is a way to change the interior color of
a
cell if no data has been entered into it after a certain amount of time.
It's the final addition to a masterpiece I've been working on for months.
If
anyone can help, I'd really appreciate it.
- NewGuy
|