Conditional Formatting vs Formulas

[Vanessa Simmonds]

Good Afternoon,

Can someone help me, please?

I have a list of code in Worksheet 2. I want to create a conditonal
formatting rule on worksheet 2 that will look for the code on Worksheet 1
Column 1 and if worksheet 1 column 2 equal active, the cell on worksheet 2
will turn green.

Is that possible using conditional formatting tool?

If not, is there any other way I could do it?

Thank you very much for your help.

Vanessa Simmonds

 

[dlw]

make a "helper" column to do a vlookup on the list in worksheet 1, and format
based on that cell.

eg: vlookup(<cell in worksheet2>,<range in worksheet1>,1)

if that is equal to the cell in worksheet2 then format it green.