Lookup and highlight matching cell with colours

See one answer in reply to your previous post.

In article ,
Mindee wrote:

Hi Hi,
To someone that can safe me.

I need to do up a formulated worksheet.
Lets say Cell A1(Red colour cell)
and Cell A2(Blue colour cell)
and Cell A3(Green colour cell)
and Cell A4,B4,C4,D4,E4,F4,G4(Yellow colour cell)
and Cell A5,B5,C5,D5,E5,F5,G5(Orange colour cell)
These cells above will be key in with numbers.(numbers that i need to
find)

Column A to J row 8 to 500, will have thousands over numbers keyed in
earlier.(numbers to be lookup)

Now i need help in this, If those numbers to be lookup matches with
those key in above, that cell should change colour accordingly. And oso
able to give me an auto tabulate numbers of colour strike.
Lets say "1000Red,500Blue,450Green,890Yellow,300Orange)

Thank you for you help!
I really need this help.
Thank you a million, and may god bless this someone sweet and helpful.

mindee