Thread: Change cell font color if time is by 15 minute intervals upto 2hr
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Change cell font color if time is by 15 minute intervals upto 2hr
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 With QuoteReply With Quote