Ask Your Question

Conditional formatting based on multiple other cells' contents?

asked 2020-02-14 02:15:26 +0100

g.reaper1982 gravatar image

updated 2020-02-14 02:15:43 +0100

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.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-14 12:05:46 +0100

gregors15 gravatar image

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.C:\fakepath\LOQ_20200214a.odt

edit flag offensive delete link more


This works perfectly! Thank you so much!

g.reaper1982 gravatar imageg.reaper1982 ( 2020-02-17 17:47:51 +0100 )edit

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.

g.reaper1982 gravatar imageg.reaper1982 ( 2020-02-17 17:53:10 +0100 )edit

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

gregors15 gravatar imagegregors15 ( 2020-02-24 14:31:27 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-14 02:15:26 +0100

Seen: 246 times

Last updated: Feb 14 '20