Conditional formatting random text

[mrkasten]

I need to have an entire row highlight red when text has been entered into column 'AB'. The problem I am running into is that the text will never be the same because it is an address. I can get the cell to turn red by using the unigue conditional formatting. I already have a macro running on this page so if that is the only way i will need help adding the new code to my exciting code.

Thanks for any future help

 

[mrkasten]

This formula filled every row. When the address like above isn't entered than the cell is blank

=AND(LEN($AB1>0),$AB1<>"Header")
</pre>

 

[Joe4]

Whoops! Had a parenthesis in the wrong place. Try this:

=AND(LEN($AB1)>0,$AB1<>"Header")

Sorry about that!

 

[mrkasten]

That was still highlighting the headers however I found a solution. I went and change the selected cell that it applies to, to $A2 instead of $A1. I have no idea how I missed that solution earlier.
Thank you so much for your help