Change thickness of Border with Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the conditional formating the border option only allows me to select a
thin border. Is there a way to select a thicker border in conditional
Formating.
 
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
if target>3 then Target.Borders.Weight = xlThick
End Sub
 
Hairline and Thin are the only two border widths available for CF.
Also, If you have a thicker regular border on an adjoining cell it can
override the CF border.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"mjlevie" <[email protected]>
wrote in message
In the conditional formating the border option only allows me to select a
thin border. Is there a way to select a thicker border in conditional
Formating.
 
Back
Top