Change color of already shaded cells

[Scotty J]

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.

 

[T. Valko]

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 Format>Conditional
Formatting. Are there any settings applied?

Biff

 

[Bob Phillips]

Sounds like conditional formatting. Select a cell, goto Format>Conditional
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]

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

 

[T. Valko]

Ok, a couple of other possibilities.

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

Goto the menu Tools>Protection. Is there an option to Unprotect?

Look for any macros (VBA code)

Hit ALT F11 to open the VBA editor
Goto View>Project 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