Formula/Conditional Formatting - HELP!!

[netchie]

Hi,

I need to track all colors that I have on A1:A5 and make sure that all of them have been listed on column B. It's a checklist and making sure that all of them have been equal from column A.

For example, let's say my Column A below is from Red to Purple, if I put "Blue" on B1, The cell that has the same color in Column A will be triggered and will be highlighted (A2). How can I get this? Also, the colors in column A are not always the same and sometimes Red is not included but Orange is. Is there a way that even if I change the color in Column A and will have the same color in Column B it will still be highlighted?

A B
1 - Red 1 - Blue
2 - Blue 2 - purple
3 - Yellow
4 - Green
5 - Purple

Please help!

Thanks in advance,
Netchie

 

[netchie]

I think I got it... thanks again and sorry for being annoying