How to change conditional formatting to rely on two cells?

[dorki_doki]

My excel knowledge is very basic. I'm making a rudimentary interactive checklist where I'm relying on conditional formatting where first the person answers a series of yes or no questions and depending on the answers, the following checklist will either grey and cross out the items or remain at the regular font. I realized that a few items on the checklist should only be greyed out if 2 of the questions are answered "No."

What's a formula I can use in conditional formatting that ensures the items are NOT greyed out unless BOTH of the required cells are marked with "No"?

Thank you.

 

[Snakehips]

@dorki_doki Welcome.

Use the AND function in your CF formula.
Below example:
I2 will CF if J2 and $J$4 = No
I3 will CF if J3 and $J$4 = No

Book2
	I	J
2	Ques 1	No
3	Ques 2	Yes
4	Ques 3	No
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:J3	Expression	=AND(J2="No",J$4="No")	text	NO

Hope that helps.

 

[dorki_doki]

@dorki_doki Welcome.

Use the AND function in your CF formula.
Below example:
I2 will CF if J2 and $J$4 = No
I3 will CF if J3 and $J$4 = No

Book2
	I	J
2	Ques 1	No
3	Ques 2	Yes
4	Ques 3	No
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:J3	Expression	=AND(J2="No",J$4="No")	text	NO

Hope that helps.

Thank you this was perfect!