I need to color code a row (10 columns) based on the value in column a being
a specific job name or number (8 to choose from). Conditional formatting
only allowed 3 conditions and only worked on individual cells.