software

I have quot;inheritedquot; a workbook used to generate budget documents. As part of
the book, there are several sheets that contain the formatted “form” which
includes boxes or borders around certain cells. My problem is I cannot change
the format of these cells using the “Format:Cells” menu or the Ctrl 1
shortcut. I can however copy a format to these cells to change them.
Unfortunately, if I happen to copy something to the cell that is
“detrimental” to my formatting I play the devil getting the formatting
corrected. Another twist is I can change all of the formatting using toolbar
functions, except for the bordering. The only way I can change the bordering
is to copy another border format to the cell. What is “wrong” with my
spreadsheet and how do I “correct” it so I can manipulate the cell formatting?

One simple question: is there anything configured in quot;Conditional
Formattingquot;? Also, does the file have some VBA that might change format? (OK
that's two questions...Sorry.)

quot;SteveBquot; wrote:

gt; I have quot;inheritedquot; a workbook used to generate budget documents. As part of
gt; the book, there are several sheets that contain the formatted “form” which
gt; includes boxes or borders around certain cells. My problem is I cannot change
gt; the format of these cells using the “Format:Cells” menu or the Ctrl 1
gt; shortcut. I can however copy a format to these cells to change them.
gt; Unfortunately, if I happen to copy something to the cell that is
gt; “detrimental” to my formatting I play the devil getting the formatting
gt; corrected. Another twist is I can change all of the formatting using toolbar
gt; functions, except for the bordering. The only way I can change the bordering
gt; is to copy another border format to the cell. What is “wrong” with my
gt; spreadsheet and how do I “correct” it so I can manipulate the cell formatting?

I don't think there is anything configured in quot;conditional formatingquot; but I
can't say for sure, I'll do more digging. I'm not familar with conditional
formating but I would've thought that once conditional, always conditional
and I wouldn't be able to quot;overridequot; by copying another format to the cell.

I hadn't thought of VBA, I'll check on that too!

THANKS!

quot;E.Q.quot; wrote:

gt; One simple question: is there anything configured in quot;Conditional
gt; Formattingquot;? Also, does the file have some VBA that might change format? (OK
gt; that's two questions...Sorry.)
gt;
gt; quot;SteveBquot; wrote:
gt;
gt; gt; I have quot;inheritedquot; a workbook used to generate budget documents. As part of
gt; gt; the book, there are several sheets that contain the formatted “form” which
gt; gt; includes boxes or borders around certain cells. My problem is I cannot change
gt; gt; the format of these cells using the “Format:Cells” menu or the Ctrl 1
gt; gt; shortcut. I can however copy a format to these cells to change them.
gt; gt; Unfortunately, if I happen to copy something to the cell that is
gt; gt; “detrimental” to my formatting I play the devil getting the formatting
gt; gt; corrected. Another twist is I can change all of the formatting using toolbar
gt; gt; functions, except for the bordering. The only way I can change the bordering
gt; gt; is to copy another border format to the cell. What is “wrong” with my
gt; gt; spreadsheet and how do I “correct” it so I can manipulate the cell formatting?

I find no quot;evidencequot; of VBA but I must confess, I really don't know how
to hunt for it!