can't remove 'fill' colour from cells 1

[Kevinski]

Hi

I have copy/ pasted some columns from a colleagues spreadsheet into one of my own.

He has used some elaborate colour-coding on his sheet by adding fill in different shades. I want to get rid of that in mine and have no fill but I can't change any of the fills. My colleague can't remember doing anything purposely to 'lock' the cells and I've gone to Tools, Protection and there's nothing set there.

Any ideas?

 

[DaleWatson123321]

Hi,

Have a look at Conditional Formatting. From the menu, it's under "Format".

A quick way to get rid of the colors would be to:
a) format a cell with the formatting you want,
b) Copy the cell
c) click on the columns,
d) Paste Special - Formats. This will leave your current formulas/values, and only copy the format.

Hope this helps ;-)

Regards, Dale Watson