Liz,

Because the colour is a result of a conditional format it's not as
straightforward as it may seem and may require quite involved code.

We may be able to devise a formula if you tell us the CF conditions that
cause the cells to change colour.

Mike

"Liz" wrote:

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.