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 target3 then Target.Borders.Weight = xlThick
End Sub

--
Don Guillett
SalesAid Software

"mjlevie" 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.

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"
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.