Hi John,

Am Fri, 5 Jun 2015 08:48:48 -0700 (PDT) schrieb John Petty:

Essentially I want
1st 6am-2pm = yellow
2nd 2:01pm-10pm = orange
3rd 10:01pm-6am = blue
And then for no color to appear at all when the cell is blank

have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for workbook "Time"
But what if working time is e.g. 11:00-16:00
or 2:00-4:00?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional