Urgent:Back ground colour

Hello

I need urgent help. I am copying a worksheet from a database (excel). The sheet has a formula that turns certain rows (depending on the values that have been entered) to either green or red.

Now the problem is that when I copy accross the selected cells - some of them are copied accross in green or red and I cannot change the background colour. No matter what I try I cannot change the back ground colour.

The cells that have no fill are fine as there colour can be changed to any thing. But the ones that are converted to green or red because of the values (there is a formula that defines when the colour should be green or red) cannot be changed in terms of colour.

Can somebody please help me it is extremely urgent. Very much appreciated.

Many thanks

so how do I change the background colour of the cells in the new worksheet to which I have copied the data? Any advice is much appreciated. Thanks