Partial Text Search in Conditional Formatting Formula

[Chris Slater]

Hi
I'm trying to work out how to apply a format to each row in my data that has a specific word, "Competition", within the text of a specific column.
As a club we run a number of competitions across the year so the word "competition" will be only part of the text. ie Competition - Trophy 1, Competition - Trophy 2 etc.
The data appears in column and row format as follows:
Column A - Description - (This is the column I will be searching in)
Column B - Date
Column C - Start Time
Column D - End Time
The Competition and it's associated Trophy will appear in the Description column and I want to highlight the row from A:D whenever the text string "Competition" appears in Column A.
The problem is that, in Conditional Formatting, the "Format only cells that contain" option does only that, namely just highlight the individual cell rather than the entire row. I also believe that Conditional Formatting doesn't support wildcards so I'm stuck what do to, I'm really hoping that one of you Geniuses/Geniei (not sure which one is correct) can help me.
Any ideas?
thanks
Chris

 

[DanteAmor]

You must use a formula to highlight other cells.

Use conditional formatting to highlight information in Excel - Microsoft Support

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

support.microsoft.com

Try:

Dante Amor
	A	B	C	D
1	Description	Date	Start Time	End Time
2	Competition - Trophy 1	05/01/2023	09:01	10:01
3	some	06/01/2023	10:01	11:01
4	Competition - Trophy 2	07/01/2023	11:01	12:01
5	data	08/01/2023	12:01	13:01
6	Competition - Trophy 3	09/01/2023	13:01	14:01
7	xd	10/01/2023	14:01	15:01
8	Competition - Trophy 4	11/01/2023	15:01	16:01
9	Competition - Trophy 5	12/01/2023	16:01	17:01
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D9	Expression	=SEARCH("Competition",$A2)	text	NO

 

[Chris Slater]

You must use a formula to highlight other cells.

Use conditional formatting to highlight information in Excel - Microsoft Support

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

support.microsoft.com

Try:

Dante Amor
	A	B	C	D
1	Description	Date	Start Time	End Time
2	Competition - Trophy 1	05/01/2023	09:01	10:01
3	some	06/01/2023	10:01	11:01
4	Competition - Trophy 2	07/01/2023	11:01	12:01
5	data	08/01/2023	12:01	13:01
6	Competition - Trophy 3	09/01/2023	13:01	14:01
7	xd	10/01/2023	14:01	15:01
8	Competition - Trophy 4	11/01/2023	15:01	16:01
9	Competition - Trophy 5	12/01/2023	16:01	17:01
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D9	Expression	=SEARCH("Competition",$A2)	text	NO

Hi Dante, Thank you very much for that. It has worked perfectly.