Conditional Format Using Formula By Referring To Another Sheet

[paul_pearson]

Thanks Excel Fox.That is excellent

I am trying to learn how you created.

I see where you used a name range for the cells = rngColors
Also i see you put in 2 entries into the name manager.Does the CF formula look at the Vect={"G","S",0} & Rslt={2,1,0} from the name manager or are these somewhere else in the spreadsheet?

You used { } ..does this mean this is a Array formula , if not what is the value of using { } ?

I have a lot more of these to add.Would you please add on the extra 3 with formulas and i will study and add all the rest

Thanks for your help

Paul