| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change cell font color if time is by 15 minute intervals upto 2h
Hi, if time = 06:00hrs in A1 what formula would be required in A2 for the
font colour to change red if by 15 minutes, green if by 30 minutes and hopfully blue, yellow etc in incrimants of 15 minutes upto 2 hours. Many thanks in advance, Rico. Extreme Novice!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell font color if time is by 15 minute intervals upto 2h
Please don't multipost.
-- David Biddulph Rico Turkses the 3rd wrote: Hi, if time = 06:00hrs in A1 what formula would be required in A2 for the font colour to change red if by 15 minutes, green if by 30 minutes and hopfully blue, yellow etc in incrimants of 15 minutes upto 2 hours. Many thanks in advance, Rico. Extreme Novice!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell font color if time is by 15 minute intervals upto
I don't understand your reply, but if anyone else in the forum knows the
answer to my original query I would be very greatful. Once more thanks in advance, Rico. "David Biddulph" wrote: Please don't multipost. -- David Biddulph Rico Turkses the 3rd wrote: Hi, if time = 06:00hrs in A1 what formula would be required in A2 for the font colour to change red if by 15 minutes, green if by 30 minutes and hopfully blue, yellow etc in incrimants of 15 minutes upto 2 hours. Many thanks in advance, Rico. Extreme Novice!! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
| How to change the font color using the Time format in a formula | Excel Discussion (Misc queries) | |||
| Change color of font base on time range | Excel Discussion (Misc queries) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| I want my X axis to have 5-10 minute intervals | Charts and Charting in Excel | |||
Hybrid Mode
