How do I add a bottom border of the current row where the `if` statement is true? I am trying to add a border if a value in a specific cell in the current row equals to `'X'`. 

So far I tried to it by conditional formatting, but for some reason, it does not work. I mark entire row (where I need the bottom border) and use "Use a formula to...", then use formula: `=$N$3='X'`. I assume that the table will copy this formatting further, but the thing is no border does show up.

As with coding, I've tried: 

```
Public Sub formating()

  Dim rng As Range
  Set rng = Range(ActiveCell.Row)

  If (ActiveCell.Value = x) Then
     With rng.Borders
         .LineStyle = xlContinous
         .Color = vbBlack
         .Weight = xlThin
     End With

End Sub

```