microsoft excel - How to apply a formatting rule to a whole row based on a cell value

I'd like to Bottom Border to a whole row where a certain cell is non-empty. I have managed to do that by using conditional formatting formula =$A2<>"" and applied that to the whole column.

My problem with that solution however is that it only creates the border only for the single cell and I want the whole row to have the border. It doesn't look like there is anything can be done from the "Format Cells" dialog.

EDIT:

Below is what I have at the moment:

And this is what I want to achieve (assume that the bottom border goes until the end of the row):

This is the conditional formatting rule that I applied:

Any other way to achieve that?

Answer

Do you want the formatting for every row to be based on the value in cell A2? If so, just select the rows you want to format, and use this conditional-formatting formula: =$A$2<>"".

If instead you want each row's formatting to be based on the value in that row's A column, just use the conditional-formatting formula you already mentioned: =$A2<>"".