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.