Problem setting borders by conditional formatting

**bagullo** · 05-17-2011, 03:01 AM

hi,

I want to make excel put a thin line if element in the first column of range changes, a gray hairline if remains the same

I have the following piece of code

Please Login or Register  to view this content.

however when it reaches the " .Weight = xlThin" line comes an error

Run-time error 1004
Unable to set the Weight property of the Border Class

however I have no problem if instead I use conditional formatting for setting font to bold for instance...

any clues in what is going wrong?

**bagullo** · 05-20-2011, 08:08 AM

Originally Posted by bagullo

hi,

I want to make excel put a thin line if element in the first column of range changes, a gray hairline if remains the same

I have the following piece of code

Please Login or Register  to view this content.

however when it reaches the " .Weight = xlThin" line comes an error

Run-time error 1004
Unable to set the Weight property of the Border Class

however I have no problem if instead I use conditional formatting for setting font to bold for instance...

any clues in what is going wrong?

Oh well, I guess I'll have to learn to live with it...

**teylyn** · 05-20-2011, 08:20 AM

Not all border settings can be used with conditional formatting. In fact, the formatting options that you can apply to a cell and the formatting options that are available for conditional formatting are quite different.

Conditional formatting will allow only a subset of all possible formatting options. As a rule of thumb: anything that changes the size of the cell will not be allowed as a conditional format.

Apparently, some border formats fall into this category.

cheers,