Highlight consecutive cells in a row and collunm from table

[Jorge Correia]

Hello,

I am trying to highlight the value "0" with conditional formating in consecutives cells (in the table) in the same row and in the same colunm like I done manualy in picture b3a.
The first value in the table is in cell B3.
I have this formula ="and(or((B3=D3,C3=b3),B3=0),or((E3=D3,F3=D3),b3=0)" but there something not working...
I know it's possible in a row but is it like I am trying?
Thank you.

 

[Jorge Correia]

=AND(B3=0,B3<>"",OR(AND(A3=0,A3<>""),AND(C3=0,C3<>""),AND(B2=0,B2<>""),AND(B4=0,B4<>"")))

=AND(B3=0;B3<>"";OR(AND(A3=0;A3<>"");AND(C3=0;C3<>"");AND(B2=0;B2<>"");AND(B4=0;B4<>"")))

It insert this in the condition. Nothing happens.
Is there someting wrong with my office?
Or is it me?

 

[Fluff]

Are those zeros actually numbers or are they text?

 

[Jorge Correia]

Are those zeros actually numbers or are they text?

They all are "zeros" (numbers) in the table and in the formula.

 

[Fluff]

In that case it should work.
If you put these two formulae into blank cells what do they return

=ISTEXT(AJ8)
=LEN(AJ8)

change AJ8 to a cell that contains a 0

 

[Jorge Correia]

In that case it should work.
If you put these two formulae into blank cells what do they return

=ISTEXT(AJ8)
=LEN(AJ8)

change AJ8 to a cell that contains a 0

In cell C5 I got a "0" (zero), so I put:
=ISTEXT(C5) in cell AV4 (blank cell, no data)
=LEN(C5) in cell AV5 (blank cell, no data)

and both return #NAME?

 

[Fluff]

What language version are you using?

 

[Jorge Correia]

What language version are you using?

Portuguese.
#NAME? (it was #NOME?)

 

[Fluff]

In that case use

=É.TEXTO(C5)
=NÚM.CARAT(C5)

 

[Jorge Correia]

In that case use

=É.TEXTO(C5)
=NÚM.CARAT(C5)

=É.TEXTO(C5) returns "FALSO" (FALSE)
=NÚM.CARAT(C5) returns "1"

 

[Fluff]

Did you translate the conditional formatting formula into your language?