Conditional Formatting

[rizmomin]

Hello:

Please refer to attached sheet.
In Sheet1 there are text which are color coded.
I need to use the same color in Sheet2 if any of this text exist in Sheet2.

Please let me know if you have any questions.
Thanks.

Riz

[JBeaucaire]

1) keep your lists in distinct columns, one color per column set

2) Create a separate CF formula for each column and set the CF color to match that column. The first formula applied to Sheet2 C3 is:

=ISNUMBER(MATCH(C3, Sheet1!$B:$B, 0)) (set this color to blue with white font)

3) Continue making more CF rules for cell C3 adjusting the formula for the correct column and color.

4) Once all CF formulas are in place, copy C3 down column C, then copy across into the other Position columns and you're good to go, start filling in jobs.

[JohnTopley]

Try ..

=MATCH($C3,Sheet1!$D$3:$D$11,0) Blue


=MATCH($C3,Sheet1!$B$3:$B$9,0) Red

repeat for columns F,I,L etc

[rizmomin]

Hi JB:

Works like a charm.
Thanks

Riz