software

When I go to use conditional formatting I find I can only use a subset of the
normal border line thicknesses. Is there any way to select a thicker border
when using conditional formatting?

No, you can only use the borders that are shown in the conditional
formatting dialog box. Conditional formatting options don't include
anything that might change the row height.

fedude wrote:
gt; When I go to use conditional formatting I find I can only use a subset of the
gt; normal border line thicknesses. Is there any way to select a thicker border
gt; when using conditional formatting?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlWell that stinks! Thanks for the info Deb.

quot;Debra Dalgleishquot; wrote:

gt; No, you can only use the borders that are shown in the conditional
gt; formatting dialog box. Conditional formatting options don't include
gt; anything that might change the row height.
gt;
gt; fedude wrote:
gt; gt; When I go to use conditional formatting I find I can only use a subset of the
gt; gt; normal border line thicknesses. Is there any way to select a thicker border
gt; gt; when using conditional formatting?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;

fedude wrote:
gt; Well that stinks! Thanks for the info Deb.
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;
gt;gt;No, you can only use the borders that are shown in the conditional
gt;gt;formatting dialog box. Conditional formatting options don't include
gt;gt;anything that might change the row height.
gt;gt;
gt;gt;fedude wrote:
gt;gt;
gt;gt;gt;When I go to use conditional formatting I find I can only use a subset of the
gt;gt;gt;normal border line thicknesses. Is there any way to select a thicker border
gt;gt;gt;when using conditional formatting?
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Contextures
gt;gt;www.contextures.com/tiptech.html
gt;gt;
gt;gt;
I discovered that if you click on the Borders icon on the Formatting
toolbar, click on Draw Borders . . . you can change the borders as thick
as you want. Yes, you will have to go over the cells by hand, but the
borders are definitely thicker!!

Deb,

Sounds like you found something however, your description lost me. The draw
borders icon on the formatting toolbar only allows you to select a border
position. I don't see what you are refering to when you say quot;Draw Bordersquot;

In the normal cell formatting menu when I select the borders tab, I can
select a line thicknes. If I select a thick line, when I leave this dialog,
I can now use the borders icon on the formatting toolbar to put a thick
border around a ceell by just using the toolbar selection. And this works
well,however, if I select a cell that has conditional formatting on it, it
always defaults to a thin line border.

Is this what you were refering to?

quot;Fancy1quot; wrote:

gt; fedude wrote:
gt; gt; Well that stinks! Thanks for the info Deb.
gt; gt;
gt; gt; quot;Debra Dalgleishquot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;No, you can only use the borders that are shown in the conditional
gt; gt;gt;formatting dialog box. Conditional formatting options don't include
gt; gt;gt;anything that might change the row height.
gt; gt;gt;
gt; gt;gt;fedude wrote:
gt; gt;gt;
gt; gt;gt;gt;When I go to use conditional formatting I find I can only use a subset of the
gt; gt;gt;gt;normal border line thicknesses. Is there any way to select a thicker border
gt; gt;gt;gt;when using conditional formatting?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;Debra Dalgleish
gt; gt;gt;Contextures
gt; gt;gt;www.contextures.com/tiptech.html
gt; gt;gt;
gt; gt;gt;
gt; I discovered that if you click on the Borders icon on the Formatting
gt; toolbar, click on Draw Borders . . . you can change the borders as thick
gt; as you want. Yes, you will have to go over the cells by hand, but the
gt; borders are definitely thicker!!
gt;

The message about using the Draw Borders toolbar was from Fancy1, not
from me. And it doesn't help with conditional formatting of borders.

fedude wrote:
gt; Deb,
gt;
gt; Sounds like you found something however, your description lost me. The draw
gt; borders icon on the formatting toolbar only allows you to select a border
gt; position. I don't see what you are refering to when you say quot;Draw Bordersquot;
gt;
gt; In the normal cell formatting menu when I select the borders tab, I can
gt; select a line thicknes. If I select a thick line, when I leave this dialog,
gt; I can now use the borders icon on the formatting toolbar to put a thick
gt; border around a ceell by just using the toolbar selection. And this works
gt; well,however, if I select a cell that has conditional formatting on it, it
gt; always defaults to a thin line border.
gt;
gt; Is this what you were refering to?
gt;
gt; quot;Fancy1quot; wrote:
gt;
gt;
gt;gt;fedude wrote:
gt;gt;
gt;gt;gt;Well that stinks! Thanks for the info Deb.
gt;gt;gt;
gt;gt;gt;quot;Debra Dalgleishquot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;No, you can only use the borders that are shown in the conditional
gt;gt;gt;gt;formatting dialog box. Conditional formatting options don't include
gt;gt;gt;gt;anything that might change the row height.
gt;gt;gt;gt;
gt;gt;gt;gt;fedude wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;When I go to use conditional formatting I find I can only use a subset of the
gt;gt;gt;gt;gt;normal border line thicknesses. Is there any way to select a thicker border
gt;gt;gt;gt;gt;when using conditional formatting?
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;--
gt;gt;gt;gt;Debra Dalgleish
gt;gt;gt;gt;Contextures
gt;gt;gt;gt;www.contextures.com/tiptech.html
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;I discovered that if you click on the Borders icon on the Formatting
gt;gt;toolbar, click on Draw Borders . . . you can change the borders as thick
gt;gt;as you want. Yes, you will have to go over the cells by hand, but the
gt;gt;borders are definitely thicker!!
gt;gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlFancy1, thanks for the advice very useful. using Draw Border (Home Ribbon,
Font buttons, hit the arrow with the border controls, go to Line Style, click
the thick one and then use Draw Border) on the selected cells which have
conditional formatting can overide and use thick formats. A bit manual but
exactly what i needed, thanks

quot;Debra Dalgleishquot; wrote:

gt; The message about using the Draw Borders toolbar was from Fancy1, not
gt; from me. And it doesn't help with conditional formatting of borders.
gt;