Force only one conditional formatting command in a column

[zitot-hawaii-edu]

I tried conditional formatting to set a style for the column with 2 rules: then I ended up with 1400 rules. Not good for performance.

The way I did it was to select the column header: this selected the whole column.
Then I created a new rule, which checked the value in some row $AB2.
Given the result it would apply either Fall or Spring Total formatting, that is, setting the background color to orange or green, for example.

I have several variant rows, let me count... at least 4 variant types I want to use. Normal rows, Fall Total, Spring Total, Year Total.

jx:if only allows two areas, functionally an if-else with no else-if, I already used it for Year Total and normal rows as I highlight the whole Year Total row.

Am I missing something here?

Potentially, is there a jx command that will set the formatting style of a cell directly? It would have to work inside an excel comment on the Excel sheet, of course.

Or, maybe a command to freeze the conditional formatting rule set so no new rules are added while creating the excel sheet?