I have a worksheet with a list of 'Special Cells' in a column, like 'C352', 'E11', etc.

How do I write a conditional formatting rule that looks through the column on the other worksheet, and if that cell is in the column, color it a certain way? I know how to do the worksheet reference and the coloring, just not how to check it the cell reference is in the column.

This will check every cell in the worksheet to see if it's in column D on worksheet2? So if D2 = 'C42' then cell C42 would be highlighted red?
–
EhrykSep 14 '12 at 2:21

For each cell you apply this conditional format to, it will highlight if its cell reference is in C1. So if you want to apply it to all cells in Column D, select Column D and enter the conditional format. You'd need to change the D4 to D1 though.
–
Rhys GibsonSep 14 '12 at 4:42