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...
HansVogelaar Is there a way to have this formula apply to more than one column without duplicating the formula and editing. I tried ending with ,D1:C1 but that did. not work all of the time. Thanks, John
Please explain in more detail what you want to accomplish.
- I was referring to the =ISNUMBER(FIND("WORD",B1)) Formula that you helped me with recently. In stead of searching just the B Column, I would like too search B and C columns for the term "Word". I have done it by creating two formulas and I was wondering if it could be done in one. John
- 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