Match Cell Fill Color to another cell in same column in Array?

Hi All,

I recently had help on this but would like to tweak the formula for a different Criteria.

I would like this Formula:

INDEX(I3:Z3,1,MATCH("A",I9:Z9))

But I would like to Match based on Cell Fill color, for example "Green", instead of the letter "A".

Is this possible?

Thanks in advance.

Originally Posted by p24leclerc

Look at the Cell function. It gives you some possibilities but I don't think you can get the actual color of it.
It could be done by macro though.

I think I am confused with what you are saying. Do you mean this may only be possible through VBA?