ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the format of a cell after a time limit (https://www.excelbanter.com/excel-programming/391740-changing-format-cell-after-time-limit.html)

newguy

Changing the format of a cell after a time limit
 
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

Vasant Nanavati

Changing the format of a cell after a time limit
 
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




newguy

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






All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com