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
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