I'm trying to finish up a Google Sheet with some conditional formatting that I can't figure out.

Here's the best description I can come up with.

If Column A matches in any row, then the formula moves on. If anything matches in Column H, I or J, then the cell in column N will turn red. If nothing matches, it turns green.

Columns H, I or J don't all have to be the same, just anything from any of those three would trigger a red cell.

I've got pull down menus so the text will be exact instead of trusting me to not mis-type something.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.