indication of empty cell

[haf]

i have rows where i have had put "+"
i want to set some kind of indicator if in that row is less then 3 empty
cells

help

 

[Jason Morin]

=IF(A1="+",COUNTBLANK(1:1)<3)

HTH
Jason
Atlanta, GA

 

[haf]

i've tried like this
=IF((D5:H5;K5:N5)="+",COUNTBLANK(1:1)<3)

but doesn't work

 

[GerryK]

Could you not simply use COUNTBLANK(1:1) and conditionally
format the cell containing the formula to red fill and red
text; based on 255 cells in a row and your requirement of
the row being less than 3 empty cells?

 

[hrlngrv]

haf wrote...

i've tried like this
=IF((D5:H5;K5:N5)="+",COUNTBLANK(1:1)<3)

but doesn't work

....

(D5:H5;K5:N5)="+" is a syntax error. Do you mean

OR(D5:H5="+",K5:N5="+")

? If so, you'd need to enter the formula

=IF(OR(D5:H5="+",K5:N5="+"),COUNTBLANK(1:1)<3)

as an array formula. Alternatively, you could use the following, longer
non-array formula.
=IF(COUNTIF(D5:H5,"+")+COUNTIF(K5:N5="+"),COUNTBLANK(1:1)<3)