Conditional formatting based on multiple other cells' contents?

I’m trying to make a conditional formatting rule to change the color of cells in column C of my spreadsheet based on the combination of responses in columns E, G, and H. I want it one color with one combination of responses, and another color based on a different combination of responsesC:\fakepath\App Tracker.ods

Example: I want the cell in column C to turn light yellow if the corresponding responses in E, G, and H are “No”, “Yes”, and “No” respectively.

HAAAALP!

Hi,
Have a look at the attached screen shots, create a style, I called mine “NoYesNo” (you can create your own name) and make the background colour Yellow.
Then highlight the range of cells/columns you want the style to be applied to, and then Format/Conditional/codition and use the drop down to select formula is and apply the formula CONCATENATE(E2,G2,H2)=“NoYesNo”, then change the apply style to NoYesNo.
Let us know if it helps.LOQ_20200214a.odt

This works perfectly! Thank you so much!

Actually, could you help me get this to apply to the entire column? I tried adding the “$” before the column letters, but it got wonky.

Hi, in the Conditional Formatting window, at the bottom use the Cell Range drop down and select the range you need.