Solved Excel 2010 - Change cell color if text equals range

Microsoft Excel 2010 - complete product...
June 27, 2012 at 11:40:51
Specs: Windows 7, Intel Core i7 M620 @2.67 GHz / 4.00 GB
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!

See More: Excel 2010 - Change cell color if text equals range

June 27, 2012 at 12:49:15
✔ Best Answer
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:


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.

Report •

June 27, 2012 at 12:59:21
Works like a charm - THANK YOU!

Report •
Related Solutions

Ask Question