Thank you.
=AND(A2=0,A2<>"")
Click on the Format button, then the Border tab, and click to select
the bottom line. OK your way out, and Excel will have adjusted the
cell references automatically.
Hope this helps.
Pete
Gord Dibben MS Excel MVP
"TrishL" <lang...@aol.com> wrote in message
news:2715e4b5-8f78-47fa...@e20g2000vbb.googlegroups.com...