Microsoft Excel 2010 - complete product...

I have a list of Products with components listed by CAS # --> Chemical Abstract Service Numbers (Syntax ######-##-#). I have another list of CAS that have had data value changes since last quarter. The other list may include duplicates, where the CAS is listed many times with numerous different changes. On my first worksheet, I'd like to indicate that there is a change, so the user knows to go look at the second sheet. Ideally, by changing the color of the cell that contains the CAS, but I can add another column and give some output, if necessary.

Your help is much appreciated!

I assume that you mean that the second list only contains CAS numbers that have a change associated with them. If that's the case, then you could use a Conditional Formatting Rule as follows: Let's say your main list of CSA numbers is in Column A and the list of CSA numbers with changes associated with them is in Column B.

Select Column A and use this CF Rule:

=NOT(ISNA(VLOOKUP(A1,$B:$B,1,0)))

This will use VLOOKUP to find the numbers from Column A in Column B. If the number exists, the NOT(ISNA(... portion will return TRUE and the cell will take on the CF format that you chose.

Note, the CSA numbers must be the only things in the cells and must match exactly.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Works like a charm - THANK YOU!

Ask Your Question

Weekly Poll

Would you be willing to go on a SpaceX trip around the moon?

Discuss in The Lounge

Poll History