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?
Printable View
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?
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.
That's not working so great some they are some that are right and they light up. everything seems right.
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?
Perfect thanks.