=COUNTBLANK(B2:F2)
, where F is the last column in your table. This formula will count the number of blank cells in each row.=IF($D2<>',3,1)
. The formula says to put 3 in column A if there is any value in the corresponding cell in column D, otherwise put 1. Naturally, you will need to replace D with the column you base your formatting on.