conditional formattinggoogle sheets
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?
You don't need a script for that; the built-in conditional formatting tools are flexible enough. Assuming the first row is for headers, apply conditional formatting to the range A2:A, with custom formula =len(join("", B2:Z2)). This means: join the content of cells, and find its length; the formatting applies if the length is greater than 0.
Replace Z by AZ or something else if you have more columns. (The formula will automatically adjust if you insert more columns between A and Z later.)
Bold formatting is found in the formatting dropdown, select "Custom" as below.
The upper left corner of the range is F2. The custom formula should be written as it applies to that cell. You have =if(F2>=F3,true) which means comparing the cell to the one below it.
To have comparison with the cell above, use =if(F2>F1, true) but it's simpler to write =F2>F1 which means the same thing.
Best Answer
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.