Having trouble with a conditional-formatting equation. I can get it to work, but for some reason, only the first cell in the range is always compared. The other cells in the range, when satisfying the same condition, will not apply the formatting.
Ex:
Cell A88 has a string in it. It never has anything else added to it. It's just a word.
Cells (range) B88:AX88 have strings in them as well. But some of the words have a space after them with a question mark or a number, like so: word ? or word 1
I'm trying to apply conditional formatting to the main word in Cell A88 (the one that never has anything added to it) based on two conditions from the cells (B88:AX88). If any cells in the range (B88:AX88) have a "?" appended to it or if it has no number appended to it, then format Cell A88 green. That's all I want to do.
Yet during testing, only when the 1st cell in the range (B88:AX88) satisfies the condition, does Cell A88 format green. If I change the 1st cell in the range to not satisfy the condition, and then alter the 2nd cell in the range to satisfy the condition, Cell A88 is not formatted green as it should be. This is the same for all remaining cells in the range. I do not understand why this is happening. Does the search function not work with a range of cells?
Also, I can't get it to work using the "?" in the search equation, even though I have it in quotation marks, so I'm using "test" as my search criteria for now until I figure that part out.
N/m, I figured out I must escape the "?" with a ~
Here is what I'm testing with currently:
Bookmarks