indication of empty cell
 

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

--
pobrisi velika slova iz mejla i sve bu okej
http://hafomatic.blog.hr/
http://www.brunkovac.com/

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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

--
pobrisi velika slova iz mejla i sve bu okej
http://hafomatic.blog.hr/
http://www.brunkovac.com/


.

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

but doesn't work

"Jason Morin" wrote in message
...
=IF(A1="+",COUNTBLANK(1:1)<3)

HTH
Jason
Atlanta, GA

-----Original Message-----
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

--
pobrisi velika slova iz mejla i sve bu okej
http://hafomatic.blog.hr/
http://www.brunkovac.com/


.

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?

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

but doesn't work

"Jason Morin" wrote
in message
...
=IF(A1="+",COUNTBLANK(1:1)<3)

HTH
Jason
Atlanta, GA

-----Original Message-----
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

--
pobrisi velika slova iz mejla i sve bu okej
http://hafomatic.blog.hr/
http://www.brunkovac.com/


.



.

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="+"),COUNTBLA NK(1:1)<3)