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/


.



.