Hello I'm trying to set up C. formatting for multiple text cells. Currently I have to add about 180 C. formatting rules to a single cell.
The first tab “Agents”, I have a static list of names. Each column represents a working shift (i.e. B1 = 7am–4pm, C1 = 8am–5pm, etc…). Below those cells is...