VBA script to return colour of Cell

[Nec87]

Hi All,

Need help on a work project.

Sheet 1 ..
Clm A | Clm B
0001 | blue
0002 | yellow
0003 | red
(there is about 500 diff colours) - all different

Sheet 2 ..
Clm A | Clm B
0003 | red
0002 | yellow

I need to show the cell colour not the text - incase your unsure.

So in short,
Sheet one has a list of about 500 diff colours, the name in the A column and the cell colour in the B column.

On sheet two I want to be able to type a colour reference in the A column and the colour to appear in the B column.

Can anyone please help me with this as a I stuck!


Thank you,

 

[Nec87]

Just a quick update. Really hoping someone can help me with this?!

Thank you kindly