I have been trying to do the following and cant get it right:
in a (validation) list H5 through h168, i have 6 different names, in a J5
through j168 , i want the cell in j5 to turn the color of the text, ie: h5
has Figdore, in J5 I want the name Blue to come up and make that cell a blue
colo.


h5 figdore = j5 blue
h6 jackson = j6 pink

Please help, thanks