Look up by the Icon Set Color

A

Alex Medina

Hello all-

Would any of you know how I can look up a range of cells with different color Icon sets ( from conditional formatting) to deliver a number range for each color?

Example, Chris has 4 Green Lights, two yellow and 3 Red.
 
Top