I want every teacher to appear in the roster to have its own color.

So I made 7 rules, on for every teachter for example: `tabname`.C5:I442 and in the condition the name of the tracher. This works fine but....

Whenever I change or copy something, zoho sheet makes a new rule for just that cell, ahusting my original rule, preventing the earlier rules to work correct. The result is that the condtional formating is not working on all the places anymore

After 10 or so corrections I have more then 100 rules. I have tot remove these by hand or remove them all and refomat the sheet. That is anoing.

How can I prevent the automatic ajustment of the conditional formating?