Conditional Format a cell in time increments

I have a macro running a timestamp for cell "d" when I make a change to cell
"c". How can I make it also change the cell colors of cell "d" after
intervals of 8, 16 & 24 hours (yellow, orange, red)?

Bojames
Thu Jul 24 22:53:00 CDT 2008

Let me add. I am novice with excel and already have 3 conditional formats
running in another cell. Will this limit my ability to add the next three?

"Bojames" wrote:

> I have a macro running a timestamp for cell "d" when I make a change to cell
> "c". How can I make it also change the cell colors of cell "d" after
> intervals of 8, 16 & 24 hours (yellow, orange, red)?
>

David
Fri Jul 25 04:53:01 CDT 2008

In another cell, no.
--
David Biddulph

"Bojames" <Bojames@discussions.microsoft.com> wrote in message
news:320B7CAF-47CD-40FB-BB81-451EB9E6D477@microsoft.com...
> Let me add. I am novice with excel and already have 3 conditional formats
> running in another cell. Will this limit my ability to add the next three?
>
> "Bojames" wrote:
>
>> I have a macro running a timestamp for cell "d" when I make a change to
>> cell
>> "c". How can I make it also change the cell colors of cell "d" after
>> intervals of 8, 16 & 24 hours (yellow, orange, red)?
>>

Bojames
Fri Jul 25 06:00:01 CDT 2008

No to what?

"David Biddulph" wrote:

> In another cell, no.
> --
> David Biddulph
>
> "Bojames" <Bojames@discussions.microsoft.com> wrote in message
> news:320B7CAF-47CD-40FB-BB81-451EB9E6D477@microsoft.com...
> > Let me add. I am novice with excel and already have 3 conditional formats
> > running in another cell. Will this limit my ability to add the next three?
> >
> > "Bojames" wrote:
> >
> >> I have a macro running a timestamp for cell "d" when I make a change to
> >> cell
> >> "c". How can I make it also change the cell colors of cell "d" after
> >> intervals of 8, 16 & 24 hours (yellow, orange, red)?
> >>
>
>
>

Pete_UK
Fri Jul 25 06:59:04 CDT 2008

You can have up to 3 conditional formats in each cell, so the fact
that you have CF set in column C does not affect column D. I think
this is what David meant by "No".

Hope this helps.

Pete

On Jul 25, 12:00=A0pm, Bojames <Boja...@discussions.microsoft.com>
wrote:
> No to what?
>
>
>
> "David Biddulph" wrote:
> > In another cell, no.
> > --
> > David Biddulph
>
> > "Bojames" <Boja...@discussions.microsoft.com> wrote in message
> >news:320B7CAF-47CD-40FB-BB81-451EB9E6D477@microsoft.com...
> > > Let me add. I am novice with excel and already have 3 conditional for=
mats
> > > running in another cell. Will this limit my ability to add the next t=
hree?
>
> > > "Bojames" wrote:
>
> > >> I have a macro running a timestamp for cell "d" when I make a change=
to
> > >> cell
> > >> "c". How can I make it also change the cell colors of cell "d" after
> > >> intervals of 8, 16 & 24 hours (yellow, orange, red)?- Hide quoted te=
xt -
>
> - Show quoted text -

David
Fri Jul 25 07:06:06 CDT 2008

No to the question which you asked, which was: "Will this limit my ability
to add the next three?"
--
David Biddulph

"Bojames" <Bojames@discussions.microsoft.com> wrote in message
news:81EC1057-2EDE-4CE0-AB05-4FBB96B18588@microsoft.com...
> No to what?
>
> "David Biddulph" wrote:
>
>> In another cell, no.
>> --
>> David Biddulph
>>
>> "Bojames" <Bojames@discussions.microsoft.com> wrote in message
>> news:320B7CAF-47CD-40FB-BB81-451EB9E6D477@microsoft.com...
>> > Let me add. I am novice with excel and already have 3 conditional
>> > formats
>> > running in another cell. Will this limit my ability to add the next
>> > three?
>> >
>> > "Bojames" wrote:
>> >
>> >> I have a macro running a timestamp for cell "d" when I make a change
>> >> to
>> >> cell
>> >> "c". How can I make it also change the cell colors of cell "d" after
>> >> intervals of 8, 16 & 24 hours (yellow, orange, red)?
>> >>
>>
>>
>>