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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.