Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
When I use the "Cell Border" button on the toolbar to put borders around
selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
ToolsOptionsView and change the colour in the Color dropdown.
-- HTH RP (remove nothere from the email address if mailing direct) "Tourkow" wrote in message ... When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
"Bob Phillips" wrote: ToolsOptionsView and change the colour in the Color dropdown. OOPS! I should have said: "Change the color of the 'printed' cell borders", not the grid lines that show on the screen. I expected to be able to change the color/type of the cell border lines under FormatCellsBorders, but that doesn't seem to work (as I would have expected it to). -- HTH RP (remove nothere from the email address if mailing direct) "Tourkow" wrote in message ... When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
After changing the color of the borders under FormatCellsBordersColor make
sure you have FilePage setupSheet set for printing in color, not "black and white". Gord Dibben Excel MVP On Thu, 24 Nov 2005 02:23:06 -0800, "Tourkow" wrote: "Bob Phillips" wrote: ToolsOptionsView and change the colour in the Color dropdown. OOPS! I should have said: "Change the color of the 'printed' cell borders", not the grid lines that show on the screen. I expected to be able to change the color/type of the cell border lines under FormatCellsBorders, but that doesn't seem to work (as I would have expected it to). -- HTH RP (remove nothere from the email address if mailing direct) "Tourkow" wrote in message ... When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
How do I make the cell border lighter weight? E.g. 0.5pt
Why does the light yellow colour (RGB 255,255,204) print so faintly? Is it something to do with the "print black and white" setting you mentioned? I thought I'd seen it print a little darker previously. "Gord Dibben" wrote: After changing the color of the borders under FormatCellsBordersColor make sure you have FilePage setupSheet set for printing in color, not "black and white". Gord Dibben Excel MVP On Thu, 24 Nov 2005 02:23:06 -0800, "Tourkow" wrote: "Bob Phillips" wrote: ToolsOptionsView and change the colour in the Color dropdown. OOPS! I should have said: "Change the color of the 'printed' cell borders", not the grid lines that show on the screen. I expected to be able to change the color/type of the cell border lines under FormatCellsBorders, but that doesn't seem to work (as I would have expected it to). HTH RP "Tourkow" wrote in message When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
How do I make the cell border lighter weight? E.g. 0.5pt
Why does the light yellow colour (RGB 255,255,204) print so faintly? Is it something to do with the "print black and white" setting you mentioned? I thought I'd seen it print a little darker previously. "Gord Dibben" wrote: After changing the color of the borders under FormatCellsBordersColor make sure you have FilePage setupSheet set for printing in color, not "black and white". Gord Dibben Excel MVP On Thu, 24 Nov 2005 02:23:06 -0800, "Tourkow" wrote: "Bob Phillips" wrote: ToolsOptionsView and change the colour in the Color dropdown. OOPS! I should have said: "Change the color of the 'printed' cell borders", not the grid lines that show on the screen. I expected to be able to change the color/type of the cell border lines under FormatCellsBorders, but that doesn't seem to work (as I would have expected it to). HTH RP "Tourkow" wrote in message When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
How do I make the cell border lighter weight? E.g. 0.5pt
Why does the light yellow colour (RGB 255,255,204) print so faintly? Is it something to do with the "print black and white" setting you mentioned? I thought I'd seen it print a little darker previously. "Gord Dibben" wrote: After changing the color of the borders under FormatCellsBordersColor make sure you have FilePage setupSheet set for printing in color, not "black and white". Gord Dibben Excel MVP On Thu, 24 Nov 2005 02:23:06 -0800, "Tourkow" wrote: "Bob Phillips" wrote: ToolsOptionsView and change the colour in the Color dropdown. OOPS! I should have said: "Change the color of the 'printed' cell borders", not the grid lines that show on the screen. I expected to be able to change the color/type of the cell border lines under FormatCellsBorders, but that doesn't seem to work (as I would have expected it to). HTH RP "Tourkow" wrote in message When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
FormatCellsBordersColor does not work for me, even on the screen. I don't
want to change ALL the borders or gridlines, just those for a few cells, which I have duly selected. Help! "Gord Dibben" wrote: After changing the color of the borders under FormatCellsBordersColor make sure you have FilePage setupSheet set for printing in color, not "black and white". Gord Dibben Excel MVP On Thu, 24 Nov 2005 02:23:06 -0800, "Tourkow" wrote: "Bob Phillips" wrote: ToolsOptionsView and change the colour in the Color dropdown. OOPS! I should have said: "Change the color of the 'printed' cell borders", not the grid lines that show on the screen. I expected to be able to change the color/type of the cell border lines under FormatCellsBorders, but that doesn't seem to work (as I would have expected it to). -- HTH RP (remove nothere from the email address if mailing direct) "Tourkow" wrote in message ... When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the color/type of the borders I put on cells?
Little trick to the sequence of applying borders and colors.
If you select the color before selecting the border type the color will hold. If you have first applied the border type then change color, you must then re-select the border type. Gord On Tue, 24 Nov 2009 13:10:02 -0800, knittertyq wrote: FormatCellsBordersColor does not work for me, even on the screen. I don't want to change ALL the borders or gridlines, just those for a few cells, which I have duly selected. Help! "Gord Dibben" wrote: After changing the color of the borders under FormatCellsBordersColor make sure you have FilePage setupSheet set for printing in color, not "black and white". Gord Dibben Excel MVP On Thu, 24 Nov 2005 02:23:06 -0800, "Tourkow" wrote: "Bob Phillips" wrote: ToolsOptionsView and change the colour in the Color dropdown. OOPS! I should have said: "Change the color of the 'printed' cell borders", not the grid lines that show on the screen. I expected to be able to change the color/type of the cell border lines under FormatCellsBorders, but that doesn't seem to work (as I would have expected it to). -- HTH RP (remove nothere from the email address if mailing direct) "Tourkow" wrote in message ... When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for the whole worksheet)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Borders Don't Line up with Cells. | Excel Discussion (Misc queries) | |||
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? | Excel Worksheet Functions | |||
i change a source and the other cells wont change | Excel Worksheet Functions | |||
Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
How do I apply a Function to a column of cells and change there va | New Users to Excel |