Hello All,
I am trying to find certain text within a given cell and have it affect the conditional format of another cell.
In column A I have a model number, say "**ABC123", (note that it has two asteriks in front of it), and in other columns I have miscellaneous cell values that I'd like to apply the conditional formatting to. I'd like to make it so that if the cell in the corresponding row, and in column A has "**" in the text, the cell format changes.
A__________________B
**ABC123________Building
ABC123__________Building
In this example B1 would be bolded conditionally because cell A1 contains two asteriks.
Does anyone have any ideas that may help?
Thanks in advance
P.s. I have tried the following:
=ISNUMBER(FIND, =ISNUMBER(SEARCH, =ISNUMBER(MATCH,
I am trying to find certain text within a given cell and have it affect the conditional format of another cell.
In column A I have a model number, say "**ABC123", (note that it has two asteriks in front of it), and in other columns I have miscellaneous cell values that I'd like to apply the conditional formatting to. I'd like to make it so that if the cell in the corresponding row, and in column A has "**" in the text, the cell format changes.
A__________________B
**ABC123________Building
ABC123__________Building
In this example B1 would be bolded conditionally because cell A1 contains two asteriks.
Does anyone have any ideas that may help?
Thanks in advance
P.s. I have tried the following:
=ISNUMBER(FIND, =ISNUMBER(SEARCH, =ISNUMBER(MATCH,