Conditional Formatting Multiple Text

[bullcreel]

I have a worksheet and in the worksheet i want to change multiple texts into one formatting. For example: I have g1c, g5c, f9x, f8x, etc. and want to use only one conditional formatting to highlight those text as "red".

Jim

 

[DanteAmor]

Assuming your data starts at A2.
Put the following formula in conditional formatting.
Choose the format you want.

=SEARCH("|"&A2&"|","|g1c|g5c|f9x|f8x|etc|")

 

[bullcreel]

It highlighted other text I didnt want it to highlight. It didnt highlight the text that I put into the formula.

I have a full worksheet that I am trying to conditional format.

 

[DanteAmor]

Then change to A1

=SEARCH("|"&A1&"|","|g1c|g5c|f9x|f8x|etc|")

Applies to:
=$1:$1048576

 

[bullcreel]

Thank You so much. I got it to work and added a bunch more text to the formula. This is going to save me a ton of work.

 

[DanteAmor]

Or in another sheet you can put the list of values, let's say from A1 to A9, with that range of cells you create a named range with the name "xvalues" and use the following formula:

=SUMPRODUCT(--ISNUMBER(SEARCH("|"&A1&"|","|"&xvalues&"|")))

Named Ranges Name: xvalues
Refers To Cells: =Sheet3!$A$1:$A$9F4

 

[bullcreel]

Or in another sheet you can put the list of values, let's say from A1 to A9, with that range of cells you create a named range with the name "xvalues" and use the following formula:

=SUMPRODUCT(--ISNUMBER(SEARCH("|"&A1&"|","|"&xvalues&"|")))

A!
Named Ranges Name: xvalues
Refers To Cells: =Sheet3!$A$1:$A$9F4

I may try that...however, I thought it was working and when I went back to the worksheet, it had screwed it all up with different colors in other rows and it had deleted some data...I probably screwed something up. I am going to try and use the list.

Maybe the problem is that i am only wanting the conditional formatting to work on 18 sections and not the whole worksheet. Wondering by putting in A1 for the whole sheet it messed everything else up.

 

[bullcreel]

Also, I just found out that it doesnt like "format painter" to allow this conditional formatting onto another sheet. It messed up the next sheet. Glad I am using a test worksheet now...lo