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?

| improve this question | |
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.

| improve this answer | |

Your Answer

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

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