Hi,

Hope you can help. I have created a formula to fill a cell with colour based
on the user input.

Eg. If cell= "R" then colour cell Red;
if cell = "A" then colour cell Gold;
If cell = "G" then colour cell Green

I hope to copy that for the whole spreadsheet, however, when I tried to copy
the format to my other cells it only took the format of the original cell.

Is there a way to solve this?

Regards,

Mary.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200606/1