| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format a cell in time increments | Excel Discussion (Misc queries) | |||
| Time Increments | Excel Worksheet Functions | |||
| i want to add increments of time not time & date | Excel Worksheet Functions | |||
| Time increments | New Users to Excel | |||
| How do I add time when some of the increments are less than an ho | New Users to Excel | |||
Linear Mode
