View Full Version : Solved: match loop up help

04-25-2007, 06:00 AM
Is it possible to have a script that looks at a range and makes sure data in that column matches a list. If something in that column does not match anything on that list then I would like for that text to change color to red and Bold?

04-25-2007, 06:22 AM
You don't need a macro--you could use conditional formatting.

For example, say you want to color the cells in column A that are not found in column B. You would select the cells in column A, then go to Format->Conditional Formatting and enter the following:

Formula Is | =COUNTIF($B:$B,$A1)=0

Then click the 'format' button to set the colors you want. Click OK until all dialogs are closed and the cells in column A should light up if they are not listed in column B.

04-25-2007, 06:33 AM
That's not working so great some they are some that are right and they light up. everything seems right.

04-25-2007, 06:37 AM
OK It seems to turn red for those that match and not for the one's that don't match. is that an easy fix?

04-25-2007, 07:07 AM
Perfect thanks.