Using =IF(AND( or the IFS functions as a formula within Conditional Formatting (CF)

[Walkon]

I am trying to highlight the entire row of a table if three conditions are met. That is, if the word "Yes" appears in cells E5, F5, and G5, then I want to format that row. I tried using:
=IF(AND($E5="Yes",$F5="Yes",$G5="Yes")) - Excel doesn't appear recognize this as a formula within CF
=IFS($E5="Yes",$F5="Yes",$G5="Yes") - Excel says there are not enough arguments in this formula
=$E5=IFS($E5="Yes",$F5="Yes",$G5="Yes") - is not recognized as a formula
=$E5="Yes" - highlights the row but I only want to highlight it if all three conditions are met

Any assistance will be greatly appreciated.

Thanks

 

[Sufiyan97]

Try

=AND($E5="Yes",$F5="Yes",$G5="Yes")

 

[Walkon]

Try

=AND($E5="Yes",$F5="Yes",$G5="Yes")

Thank-you for this. I just tried it and no luck. Below is a picture of the response from excel.

 

[Peter_SSs]

I just tried it and no luck.

You have changed the formula suggested. In it you have a "." where it should be a ","

Another form of the formula you could use would be

=COUNTIF($E5:$G5,"Yes")=3

 

[Walkon]

You have changed the formula suggested. In it you have a "." where it should be a ","

Another form of the formula you could use would be

=COUNTIF($E5:$G5,"Yes")=3

Thanks for the quick reply! I corrected my error of using a period instead of a comma in the =AND( formula but got the same response. However, when I tried the COUNTIF( suggestion it worked perfectly! Thanks very much.

 

[Peter_SSs]

I corrected my error of using a period instead of a comma in the =AND( formula but got the same response.

Then to be honest I think that you must have made some other error with it as the post #2 formula works fine for me.

24 12 18.xlsm
	A	B	C	D	E	F	G	H	I
5					Yes	No	Yes
6					Yes	Yes	Yes
7					No	No	No
8					Yes		Yes
9
10					Yes	Yes	Yes
YesYesYes

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5:I10	Expression	=AND($E5="Yes",$F5="Yes",$G5="Yes")	text	NO

Anyway, I guess the main thing is that you have something that works.

 

[Walkon]

=AND($E5="Yes",$F5="Yes",$G5="Yes")

I just re-checked and you are correct, it works. My apologies for wasting people's time.
Thanks again for you assistance.