Forum Discussion
Macros or Find
I am seeking to find a way to search a worksheet and find cells in a column which contain a single word or two amongst the many that may be in the cell and have that trigger a color reformat of an a...
Now I am confused. My sheet consists of 3 columns A,B, and C. My Goal is to Find 5 Different terms in either B Column or C Column. Depending upon which Term is found in either B or C or Both, A is then conditioally formatted the appropriate color. To accomplish this I have 12 Conditional Formatting formulas. I am enclosing a screen shot to Show you these. I keep thinking that I should be able to search both Column B and C and Reformat A with one formula. I haven't been able to accomplish that. I also ran into a problem when a row in A or B or both contained more than one of the terms in my search group such as "Jamestown" and "New York". Formula order took care of most of that.
/var/folders/cs/8bsmwb2x68j2nz15zj4xcq0m0000gq/T/com.apple.mail/com.apple.mail.drag/Screen Shot 2021-05-05 at 10.49.36 AM.png
/var/folders/cs/8bsmwb2x68j2nz15zj4xcq0m0000gq/T/com.apple.mail/com.apple.mail.drag/Screen Shot 2021-05-05 at 10.49.36 AM.png
- /Users/john/Ancestry/Tree people list Ancestry.xlsx
From John HicksI'm sorry - this won't work. You have posted the path to the file on your local hard disk, but we cannot get at that of course.
Attach the workbook by dragging and dropping it into a reply.
- I sent an email back with the file but I could not get it to work with your web site Reply. So I sent it regular E mail to the address that showed up when I hit respond on your incoming email. John
The screenshot hasn't come through. Perhaps you could attach a sample workbook?