Highlight a specific text in a text string

How can I highlight a text in a text string?

You can use this CF formula:

=AND($B$1<>"",COUNTIF($B5,"*"&$B$1&"*"))

Applied to the range B5:B8.

Also, you can change the formula in G5 to this:

=COUNTIF($B$5:$D$8, "*"&F5&"*")

then copy it down, rather than have 5 individual formulae.

Hope this helps.

Pete

=COUNTIF(B5,"*"&$B$1&"*")

applies to =$B$5:$D$8

If you want to highlight cells in the table from the other stores, then use this CF formula:

=AND($B$1<>"",COUNTIF(B5,"*"&$B$1&"*"))

Note that I have removed the $ symbol.

Apply this to the range B5:D8

Hope this helps.

Pete

Originally Posted by Pete_UK

If you want to highlight cells in the table from the other stores, then use this CF formula:

=AND($B$1<>"",COUNTIF(B5,"*"&$B$1&"*"))

Note that I have removed the $ symbol.

Apply this to the range B5:D8

Hope this helps.

Pete

Thanks, Pete! This is what I was looking for and figured out that it was just a matter of removing $ from B5. Cheers!

Glad to help, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete