I want the first 3 cells in a row to be filled with a certain color only if the rest of the row is blank. Is there an easier way?

user_5595643 0
Viewed 49
=AND(ISBLANK(D2:D98), ISBLANK(E2:E98), ISBLANK(F2:F98), ISBLANK(G2:G98), ISBLANK(H2:H98), ISBLANK(I2:I98), ISBLANK(J2:J98), ISBLANK(K2:K98), ISBLANK(L2:L98), ISBLANK(M2:M98), ISBLANK(N2:N98))

This is what I have for my custom formula -- and it works. It's just very time consuming to implement and edit. Is there a better way?

Using Google Sheets, but can and would switch to Excel 2013 (what is available to me at work) if it would make a difference.

google-workspace google-sheets-formula spreadsheet google-sheets excel
1 Answers

with a range of A2:C,

=AND(COUNTA($A2:$C2)>=1,COUNTA($D2:$N2)=0)

This will check for anything in the first three columns and also if D:N on the same row is blank.

user_122540980
Related