Thanks for the reply
I did use a macro recorder, but not sure how to have the thick Border Box aroond the values in the same row where the text in Col, A is highlighted
I have attempted to write code but need help in completing this
Will most propably have to have this as a Private Sub to be copied in the code for the applicable sheet
Your assistance in resolving this is most appreciatedCode:Sub Borders () If Text.bold = True Then ????? With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous Else Exit Sub next End with End Sub




Reply With Quote
Bookmarks