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 amp; trace each cell by hand, but the borders
are definitely thicker!!
You could do this with a macro. From vba help
Worksheets(quot;Sheet1quot;).Range(quot;A14quot;).BorderAround _
ColorIndex:=3, Weight:=xlThick
--
Don Guillett
SalesAid Software
quot;Fancy1quot; gt; wrote in message
...
gt;I discovered that if you click on the Borders icon on the Formatting
gt;toolbar, after you have created your Conditioning Formatting, click on Draw
gt;Borders . . . you can change the borders as thick as you want. Use the
gt;slide bar and scroll down to select the border you want. You will have many
gt;to choose from.
gt;
gt; Yes, you will have to go over amp; trace each cell by hand, but the borders
gt; 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:
gt; I discovered that if you click on the Borders icon on the Formatting
gt; toolbar, after you have created your Conditioning Formatting, click on
gt; Draw Borders . . . you can change the borders as thick as you want. Use
gt; the slide bar and scroll down to select the border you want. You will
gt; have many to choose from.
gt;
gt; Yes, you will have to go over amp; trace each cell by hand, but the borders
gt; are definitely thicker!!--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
- Oct 05 Fri 2007 20:40
Conditioning Formatting
close
全站熱搜
留言列表
發表留言