Color cells

  • Thread starter Thread starter Mark Durrenberger
  • Start date Start date
M

Mark Durrenberger

Hi, I'm working with the loan amortization template that is shipped with
Excel 2002.

The bacground on a number of cells are colored pale yellow.

I don't know how to clear the color or change it. I've tried the paint
bucket but that does not do it.
I also cannot turn on gridlines.

Thanks in advance,
Mark
 
That's because you're not supposed to. The yellow highlights the summary
area and requires no user intervention. If you really want to change it you
need to do Tools / Protection / Unprotect sheet (There is no password
assigned). You will then find you can format as you wish.
 
That was one of the first things I did, and I still can't change the
cells...

So no that's not it ????

Mark


--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones
 
Well it certainly works on the standard template as I can do the same on
either my work machine or my home one, and each have different Office
installs on them.

Were the sheets protected initially, and are you actually able to select the
cells, just not format them?
If you are able to select them then what do you see if you use Format /
Cells / Patterns tab - Can you do anything with this - does it appear to let
you and then just not take?
 
Assuming you haven't changed the structure of the template, try running this
and let me know what happens:-

Sub ColCells()

With ActiveSheet
Range("H6:H10").Interior.ColorIndex = xlNone
End With

End Sub
 
Ahhhhh - You're talking about the formatting on the rows below the summary
data, whereas i am referring to the summary data itself. That is done with
conditional formatting. Select the cells and do format / conditional
formatting and simply delete the conditions.
 
Ken, Thanks. Mark

--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones
 
Back
Top