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

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

[Jason Morin]

=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]

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

but doesn't work

"Jason Morin" <[email protected]> wrote in message
news:[email protected]...
> =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/
>>
>>
>>.
>>

[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?

>-----Original Message-----
>i've tried like this
>=IF((D5:H5;K5:N5)="+",COUNTBLANK(1:1)<3)
>
>but doesn't work
>
>"Jason Morin" <[email protected]> wrote
in message
>news:[email protected]...
>> =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/
>>>
>>>
>>>.
>>>
>
>
>.
>

[[email protected]]

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)