PC Review


Reply
Thread Tools Rate Thread

Changing the format of a cell after a time limit

 
 
=?Utf-8?B?TmV3R3V5?=
Guest
Posts: n/a
 
      20th Jun 2007
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
 
Reply With Quote
 
 
 
 
Vasant Nanavati
Guest
Posts: n/a
 
      21st Jun 2007
After a certain amount of time since when?
_____________________________________________________________________

"NewGuy" <(E-Mail Removed)> wrote in message
news:12B297C7-BDEE-45E2-9BBD-(E-Mail Removed)...
> 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



 
Reply With Quote
 
=?Utf-8?B?TmV3R3V5?=
Guest
Posts: n/a
 
      21st Jun 2007
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" <(E-Mail Removed)> wrote in message
> news:12B297C7-BDEE-45E2-9BBD-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to stop time format changing when I merge cell contents? CatKween Microsoft Excel Worksheet Functions 3 6th Apr 2010 07:56 PM
Limit to hours in elapsed time format? Kaykayme Microsoft Excel Programming 3 9th Nov 2009 02:06 PM
limit on [h]:mm time format? =?Utf-8?B?U3RlZmk=?= Microsoft Excel Misc 14 22nd Feb 2007 10:30 AM
changing normal number format that appears as a time to time forma =?Utf-8?B?UmljaGFyZCBLYW50ZWNraQ==?= Microsoft Excel Misc 1 14th Sep 2004 12:33 PM
Changing number format to time format issue Iain Microsoft Access Queries 1 28th Nov 2003 02:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:33 PM.