I'm collaborating on a Google Sheet with approximately 500 rows. I think potentially could use IF, ISBLANK and conditional formatting but I can't conceptualize a formula for this and I've tried reading examples. This Google Sheet has unique rows, but I cannot change the text which is why would like to conditionally format.
- J cell should be highlighted if text is "Not Met" AND column M is blank.
- K cell should be highlighted if text is "Not Met" AND column N is blank.
- I is the ultimately important column and should be highlighted if (J is "Not Met" AND M is blank) AND if (K is "Not Met" and N is blank). For example, the last row in the photo does not need to be highlighted because J is "Not Met" but is fulfilled by data in M AND K includes "Met".
- Additionally, if L cell has any data then I should not be highlighted (overrides J,K,M,N data).
I'm unable to print in color, so don't want to highlight green for "Met" or if J thru N fulfill the requirements, it should remain as is.
Is this possible?