Conditional Formatting Highlighting entire row issue

[Dxmiian]

Hi.
I have an issue when trying to use conditional formatting to highlight row.
My sheet has row 1 as titles and questions and row 2 from C2:X100 is my area for pass & Fail answers. I want any row containing fail to be highlighted.
Ive been able to highlight each cell but not the entire row.
any help would be appreciated.

Thanks,

Damian

 

[arthurbr]

Select the entire range C2:X100
use the following CF

=COUNTIF($C2:$X2,"Fail")

( the referencing is the important part) and format as required

 

[Peter_SSs]

Since your range is not very big it probably will not make a noticeable difference but using a 'MATCH' type function should be a little less resource-hungry so that would be my recommendation.

23 08 26.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
2	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Fail
3	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass
4	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Fail	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass
5	Pass	Pass	Pass	Pass	Pass	Pass											Pass	Pass	Pass	Pass	Pass	Pass
6	Pass	Pass	Pass	Fail	Pass	Pass	Fail	Pass	Pass	Fail	Pass	Pass	Pass	Pass	Fail	Pass	Pass	Pass	Pass	Pass	Pass	Pass
7	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass
8	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass
9
10	Pass	Pass	Pass	Pass	Pass	Pass	Fail	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Fail	Pass	Pass	Pass	Pass
Fail

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:X10	Expression	=XMATCH("Fail",$C2:$X2)	text	NO

 

[Dxmiian]

Since your range is not very big it probably will not make a noticeable difference but using a 'MATCH' type function should be a little less resource-hungry so that would be my recommendation.

Hi,

this works perfect for certain answers. an issue im encountering with it, is my answers come from Microsoft forms using flow. the word fail in most questions present as "["Fail"]" so the formula isnt reading that correctly.

is there a way i can get it to just read the text and not [""] also ?

 

[Peter_SSs]

Change the CF formula to

=XMATCH("*Fail*",$C2:$X2,2)

 

[Dxmiian]

Change the CF formula to

=XMATCH("*Fail*",$C2:$X2,2)

Thanks for the help, i really do appreciate it!

 

[arthurbr]

Once again, not even an acknowledgment...

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.