Quote Originally Posted by teylyn View Post
If I select a few cells, merge them, then enter the text, the conditional formatting will show. Does it not do that for you?
The problem is if you merge cells say B7:B10(9.00am-11.00am) for a certain slot then you were to come back to it and want to change the schedule so you then unmerged the cells and merged B8:B10(09.30am-11.00am) the formatting will not work. If you click the CF tab/manage rules you will see the "applies to" range is totally different from the range originally formatted (B3:G32).

Same seems to happen if I cut/copy & paste cells.

Have reattached file to show what I mean!!
Col


Example of weekly plan only.xlsx