If I have a spreadsheet where I used colors for conditional formatting, how
would I rank those items. For example

store 1 green yellow yellow green
store 2 yellow green green green

I want to use a formulat that would tell me how many times the green
formatting is in store 1 and 2 and then perform a rank.