Adding an underline to a row where a certain cell value exists

In the attached xls example I'm looking to add a border underline across the entire row where a certain cell contains the value address type.

So in the attached example, I want a border at the bottom of each cell across rows 4 and 10.

I've put a before and after example across two sheets in the xls too.

What would the vba script need to look like for that?

VBA question.xlsx

Don't need VBA for that. You can use conditional formatting.

Could you advise how to set that up in Conditional Formatting please? I can't see how I would apply a bottom border to the entire row where a cell value is x. I'm only able to apply that formatting to that one cell currently.

When you create the conditional, there is a button to format it. Go to border then just click the bottom border. You can change the line type (dashed, solid, etc) and the color from there as well. If you want to underline the text, you can also do that from the Font tab.

When I do that, it only applies a border to the cell that contains the value x.

I need a border applied to the whole row where a cell contains value x.

Hence me thinking this needs to be a VBA solution.

So, if the column you are looking at for the value of x was in E, you want to apply this conditional formula to all the columns you want. I will use the assumption that your data is in columns A:E and your x value will appear in column E. So, highlight columns A:E then use this:

=$E1=x

Here's an example.

Thank you, that worked