HELP Excel 2007. Background Colour tabs blocked?

G

Guest

Good Morning.

I seem to be having a bit of trouble trying to allow a user to use the
background colour button in excel 2007. The user wants to colour certain
cells in their spreadsheet but are unable to as the buttons you would
normally use are ghosted out (unable to be used). Is there anyway to allow
this. Im an excel 2003 user so 2007 is a very new experience for me.

Anyones help would be much appreciated.
 
R

Roger Govier

Hi

Colouring the cells is the same as in XL2003.
It sounds as though their sheet is protected.
Right click on sheet tab>Unprotect
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
How do you copy colour from one workbook to another in Excel 2007 2
excel 2007 olour display problem 4
text and background colour 2
Excel 2007 change colour when "find" function is used 1
Change colour of worksheet tabs in Excel 5
Background colour grey on entire worksheet 3
Formula help 3

Top