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!