0

I am trying to format a cell to have white text & white fill if any of several other cells are blank. I excel, I would use =OR(K2="",P2="",Q2="",R2="",S2="",T2="",U2="",V2="",W2="",X2="",Y2="",Z2="",AB2="",AF2="")

This is not working in google sheets. Any suggestions?

1
=ARRAYFORMULA(OR(isblank({K2,P2,Q2,R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AB2,AF2})))

ISBLANK() will check if each cell within the provided array is blank.

OR() compacts all the results into a single Boolean value. Without it the function will still check every cell you listed but will only change the formatting based on whether or not the first cell, K2, is empty.

ARRAYFORMULA() is necessary in order to allow ISBLANK() to take an array as a parameter. It prefers to work with a single cell otherwise.

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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.