Thread
:
Change cell font color if time is by 15 minute intervals upto 2hr
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
Posts: 2,389
Change cell font color if time is by 15 minute intervals upto 2hr
What version of Excel do you have? Whether you can do what you want will
depend on your version.
Regards,
Fred
"Rico Turkses the 3rd" <Rico Turkses the
wrote in message ...
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 With Quote
Fred Smith[_4_]
View Public Profile
Find all posts by Fred Smith[_4_]