I'm trying to create a schedule chart that allows me to see what periods of a range have been scheduled. I have been able thru conditional formatting to highlight the cells yellow for the scheduled time (start / end). I’d like to be able to have two different highlight colors. I tried various conditional formulas to try to get the time blocks to highlight black where Unit in column A is X and Yellow highlights for all other units , but couldn't get it to work. I have posted sample spreadsheet to one drive https://1drv.ms/x/s!Ai2z2uOS2mdJbIvl6UrlCSbhd3A
Thanks
Thanks