Changing value in Column A depending on value in Column A, B

[jmh1]

Hi, I have a table that has 2 columns, A and B.


Each column contains multiple values.

I need to write a macro that will look at Column A, and IF it is "1," THEN look at Column B for any cells with "Red," "blue," or "orange" and change Column A to "Yes."


If Column A is not "1," then I do not want to change Column A, regardless of what is in Col. B.

If Col. A is "1", but Col. B is not "red" "blue", or "orange", then I do not want to change Col. A.

Any help would be much appreciated.

thanks

 

[HalfAce]

Hi lenze.
Yep. There was a speed change in that. (and now it is as I would've expected when I saw your
code yesterday - the case select is quicker.)

Average of 10 runs on 11,520 rows (on a different machine that yesterday). . .
SeeIt(): 0.321875 second
FindColorsDemo(): 0.385937 second