Conditional Formatting Borders

[kp91149]

I want to set up conditional formatting so that if a cell has data the entire row will automatically get borders. The possible columns that can have data are A:E. The rule I am using is =OR(A1<>"",B1<>"",C1<>"",D1<>"",E1<>"") and applies to =$A:$E. This mostly works but if for example only cell A has data the borders are only applied to cell A and not the rest of the row. On the other hand if only cell E has data the borders are applied to all cells in the row (A:E). I can only imagine that I have messed up something in how the rule is applied but for the life of me I can't understand the logic here. I can get it to work if I create 5 separate rules and apply it to only one column at a time but I am hoping there is some way to roll it into one rule. Any suggestions?

 

[Scott Huish]

Select columns A:E and try this as your Conditional Formatting Formula:
=COUNTA($A1:$E1)

 

[kp91149]

Perfect, that does the job exactly. Why is the correct answer always a more simple formula than the convoluted and complicated one you try first? Thanks!