Thread: Change cell font color if time is by 15 minute intervals upto 2h
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rico Turkses the 3rd Rico Turkses the 3rd is offline
external usenet poster
  
Posts: 3
Default 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!!
Reply With QuoteReply With Quote