Is there a way to assign a specific value to a "stoplight conditions (
without having to write a complicated "if" statement in order to summarize a
group of individual rules into a single "stoplight" when the actual data does
not normalize easily. ?

in other words, is there something behind the scenes in conditional
formating that "knows" that a cell is red, yellow or green that can be
combined into in new summary rules ?

I am rolling up a 100 query dashboard into small groups