Conditional Formatting absolute reference issue

[Tmini]

Hi
I have an issue where I want to colour a range of cells based on a few variables. It works well if I only use the formula for one row but as soon as I try to enable it for multiple rows it won't work. Nothing highlights unless all of the cells in colmun A contains the variable I am looking for, and only the first row is highlighted and not all of them like they should be. If only a couple cells contain the variable then it won't highlight anything. I know I am doing something wrong I am just unsure what it is. The formula I am using is as follows

=AND($B4:$B6=0,$A4:$A6 <> "")

and it applies to $A$4:$H$6. Can someone help with what I am doing wrong for it to not highlight the cells I want highlighted based on the rules I have applied

 

[Tetra201]

Try

=AND($B4=0,$A4<>"")

applied to $A$4:$H$6

 

[Tmini]

Thanks heaps for that Tetra that worked a treat. Why is it mine didn't work?

 

[Tetra201]

You are welcome.

Your CF rule didn't work because it translated into:

=AND($B4=0,$B5=0,$B6=0,$A4<>"",$A5<>"",$A6<>"") for range A4:H4
=AND($B5=0,$B6=0,$B7=0,$A5<>"",$A6<>"",$A7<>"") for range A5:H5
and so on.

 

[Tmini]

Ahh I see now thanks for the explanation