Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Thick Border?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Thick Border?
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: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Thick Border?
Well that stinks! Thanks for the info Deb.
"Debra Dalgleish" wrote: 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: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Thick Border?
fedude wrote:
Well that stinks! Thanks for the info Deb. "Debra Dalgleish" wrote: 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: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html 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!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Thick Border?
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 "Draw Borders" 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? "Fancy1" wrote: fedude wrote: Well that stinks! Thanks for the info Deb. "Debra Dalgleish" wrote: 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: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html 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!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Thick Border?
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: 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 "Draw Borders" 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? "Fancy1" wrote: fedude wrote: Well that stinks! Thanks for the info Deb. "Debra Dalgleish" wrote: 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: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html 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!! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Thick Border?
Fancy1, 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 "Debra Dalgleish" wrote: The message about using the Draw Borders toolbar was from Fancy1, not from me. And it doesn't help with conditional formatting of borders. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |