Change color of already shaded cells
 

I was given a worksheet with several cells already shaded. There is no
data or values in these cells. I was wondering how I could change the
color on those specific cells.

Change color of already shaded cells
 

If you tried to manually change the the fill color and it didn't work a
possibility is that the cells are conditionally formatted. Conditional
formatting will override manual formatting.

Select a cell that is shaded and goto the menu FormatConditional
Formatting. Are there any settings applied?

Biff

"Scotty J" wrote in message
oups.com...
I was given a worksheet with several cells already shaded. There is no
data or values in these cells. I was wondering how I could change the
color on those specific cells.

Change color of already shaded cells
 

Sounds like conditional formatting. Select a cell, goto FormatConditional
Formatting, and see if there is anything there.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Scotty J" wrote in message
oups.com...
I was given a worksheet with several cells already shaded. There is no
data or values in these cells. I was wondering how I could change the
color on those specific cells.

Change color of already shaded cells
 

I did this, and it says there is "No Format Set".

Change color of already shaded cells
 

Ok, a couple of other possibilities.

The sheet may be protected or there may be some VBA code doing this.

Goto the menu ToolsProtection. Is there an option to Unprotect?

Look for any macros (VBA code)

Hit ALT F11 to open the VBA editor
Goto ViewProject Explorer
Locate your file name

Do you see any modules listed?

Double click the sheet name. Do you see any code in the window that opens?

Biff

"Scotty J" wrote in message
ups.com...
I did this, and it says there is "No Format Set".