Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell border problem
Hi,
I have a question about applying borders in cells (Excel 2003, Win XP pro). I am having problems putting a border on cells that have conditional formatting applied to it. I have tried different colours and sizes. I format the border with a different colour and size of line and I can see it on the screen. I go to print preview and it is not there. I go and print it out and it is not there. Also, if I go to the next empty cell beside it (with no conditional formatting) and try and put a border on this empty cell, the border will not work. Any suggestions on what to do next and/or try next would be greatly appreciated. Sincerely, Brian. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell border problem
the default for conditional formatting is no borders, when stting the
formats, choose the second tab "Borders" and select the one you want, i'll bet that fixes ya. -- -John Please rate when your question is answered to help us and others know what is helpful. "Brian" wrote: Hi, I have a question about applying borders in cells (Excel 2003, Win XP pro). I am having problems putting a border on cells that have conditional formatting applied to it. I have tried different colours and sizes. I format the border with a different colour and size of line and I can see it on the screen. I go to print preview and it is not there. I go and print it out and it is not there. Also, if I go to the next empty cell beside it (with no conditional formatting) and try and put a border on this empty cell, the border will not work. Any suggestions on what to do next and/or try next would be greatly appreciated. Sincerely, Brian. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell border problem
Hey, that worked! Thank you very much.
Is there a way to apply a border without changing the conditional formatting? Or, is that the only way. Brian. "John Bundy" wrote: the default for conditional formatting is no borders, when stting the formats, choose the second tab "Borders" and select the one you want, i'll bet that fixes ya. -- -John Please rate when your question is answered to help us and others know what is helpful. "Brian" wrote: Hi, I have a question about applying borders in cells (Excel 2003, Win XP pro). I am having problems putting a border on cells that have conditional formatting applied to it. I have tried different colours and sizes. I format the border with a different colour and size of line and I can see it on the screen. I go to print preview and it is not there. I go and print it out and it is not there. Also, if I go to the next empty cell beside it (with no conditional formatting) and try and put a border on this empty cell, the border will not work. Any suggestions on what to do next and/or try next would be greatly appreciated. Sincerely, Brian. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving an file with charts as a webpage - border problem | Excel Discussion (Misc queries) | |||
bottom double border shorcut key problem | Excel Discussion (Misc queries) | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
Default Border Color Problem | Excel Discussion (Misc queries) | |||
only last cell on page to have bottom border (cell area outline) | Excel Worksheet Functions |