View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newguy newguy is offline
external usenet poster
 
Posts: 19
Default 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