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)?

Conditional Format a cell in time increments
 

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)?

Conditional Format a cell in time increments
 

In another cell, no.
--
David Biddulph

"Bojames" wrote in message
...
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)?

Conditional Format a cell in time increments
 

No to what?

"David Biddulph" wrote:

In another cell, no.
--
David Biddulph

"Bojames" wrote in message
...
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)?

Conditional Format a cell in time increments
 

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*pm, Bojames
wrote:
No to what?



"David Biddulph" wrote:
In another cell, no.
--
David Biddulph

"Bojames" wrote in message
...
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)?- Hide quoted text -

- Show quoted text -

Conditional Format a cell in time increments
 

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

"Bojames" wrote in message
...
No to what?

"David Biddulph" wrote:

In another cell, no.
--
David Biddulph

"Bojames" wrote in message
...
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)?