Conditioning Formatting - Thicker Borders

I discovered that if you click on the Borders icon on the Formatting
toolbar, after you have created your Conditioning Formatting, click on
Draw Borders . . . you can change the borders as thick as you want. Use
the slide bar and scroll down to select the border you want. You will
have many to choose from.

Yes, you will have to go over & trace each cell by hand, but the borders
are definitely thicker!!

You could do this with a macro. From vba help

Worksheets("Sheet1").Range("A1:D4").BorderAround _
ColorIndex:=3, Weight:=xlThick

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Fancy1" <drahim@discussions.microsoft.com> wrote in message
news:OCw0onHfGHA.1208@TK2MSFTNGP02.phx.gbl...
>I discovered that if you click on the Borders icon on the Formatting
>toolbar, after you have created your Conditioning Formatting, click on Draw
>Borders . . . you can change the borders as thick as you want. Use the
>slide bar and scroll down to select the border you want. You will have many
>to choose from.
>
> Yes, you will have to go over & trace each cell by hand, but the borders
> are definitely thicker!!

What happens when the cell value no longer meets the conditions for
borders? Do you manually remove the thick lines?

Fancy1 wrote:
> I discovered that if you click on the Borders icon on the Formatting
> toolbar, after you have created your Conditioning Formatting, click on
> Draw Borders . . . you can change the borders as thick as you want. Use
> the slide bar and scroll down to select the border you want. You will
> have many to choose from.
>
> Yes, you will have to go over & trace each cell by hand, but the borders
> are definitely thicker!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html