Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats "Bleed" down Columns
On some worksheets that have rows highlighted in a color, when I type in a
plain white row below some cells will pick up the color above and I end up with a checker board across. No matter how many times I may format a row to be free of any color, when I go to enter information then the same cells will bleed the above colors. Just briefly, I color rows certain colors to symbolize if the infomation has gone out to its recipients and if it has come back fully reviewed. But it is agravating if certain cells are doing this 'bleeding' before and I constantly have to adjust. Can anyone give me tips. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats "Bleed" down Columns
Do you have any conditional foramtting for those cells which is turning them
colour? "Thomas" wrote: On some worksheets that have rows highlighted in a color, when I type in a plain white row below some cells will pick up the color above and I end up with a checker board across. No matter how many times I may format a row to be free of any color, when I go to enter information then the same cells will bleed the above colors. Just briefly, I color rows certain colors to symbolize if the infomation has gone out to its recipients and if it has come back fully reviewed. But it is agravating if certain cells are doing this 'bleeding' before and I constantly have to adjust. Can anyone give me tips. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats "Bleed" down Columns
Thomas
ToolsOptionsEdit. Uncheck "extend data range formats and formulas" Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 08:41:02 -0800, Thomas wrote: On some worksheets that have rows highlighted in a color, when I type in a plain white row below some cells will pick up the color above and I end up with a checker board across. No matter how many times I may format a row to be free of any color, when I go to enter information then the same cells will bleed the above colors. Just briefly, I color rows certain colors to symbolize if the infomation has gone out to its recipients and if it has come back fully reviewed. But it is agravating if certain cells are doing this 'bleeding' before and I constantly have to adjust. Can anyone give me tips. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats "Bleed" down Columns
Couple of thoughts on the subject from yesterday...
http://snipurl.com/13fpl -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Thomas" wrote in message On some worksheets that have rows highlighted in a color, when I type in a plain white row below some cells will pick up the color above and I end up with a checker board across. No matter how many times I may format a row to be free of any color, when I go to enter information then the same cells will bleed the above colors. Just briefly, I color rows certain colors to symbolize if the infomation has gone out to its recipients and if it has come back fully reviewed. But it is agravating if certain cells are doing this 'bleeding' before and I constantly have to adjust. Can anyone give me tips. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats "Bleed" down Columns
Thanks. That did work.
"Gord Dibben" wrote: Thomas ToolsOptionsEdit. Uncheck "extend data range formats and formulas" Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 08:41:02 -0800, Thomas wrote: On some worksheets that have rows highlighted in a color, when I type in a plain white row below some cells will pick up the color above and I end up with a checker board across. No matter how many times I may format a row to be free of any color, when I go to enter information then the same cells will bleed the above colors. Just briefly, I color rows certain colors to symbolize if the infomation has gone out to its recipients and if it has come back fully reviewed. But it is agravating if certain cells are doing this 'bleeding' before and I constantly have to adjust. Can anyone give me tips. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unchecking "Extend data range formats" is not workingfor row shading
I have rows that are shaded a color. I would like new rows I insert to not be shaded.
I unchecked "Extend data range formats and formulas", but new inserted rows are still shaded. I unchecked Tools/Auto Correct/Auto Format/"Include new rows and columns in list" but that didn't help either. How can I make the default fill color for new rows inserted between two shaded rows be "no fill"? EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unchecking "Extend data range formats" is not workingfor row shading
I have rows that are shaded a color. I would like new rows I insert to not be shaded.
I unchecked "Extend data range formats and formulas", but new inserted rows are still shaded. I unchecked Tools/Auto Correct/Auto Format/"Include new rows and columns in list" but that didn't help either. How can I make the default fill color for new rows inserted between two shaded rows be "no fill"? EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and link formats from cell to cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) | |||
Too Many Different Cell Formats | Excel Worksheet Functions |