On Thu, 27 Sep 2012 10:07:31 +0100, Martin ©¿©¬
wrote:

On Wed, 26 Sep 2012 15:22:08 -0700 (PDT), Don Guillett
wrote:

On Wednesday, September 26, 2012 10:30:41 AM UTC-5, Martin ©¿©¬ wrote:
Hi

I have a spreasheet with 16 pages & have some set to change colour

(blue) when new data is entered into a cell.
How would I remove this colour change from all the remaining pages &

could this be done in one operation?

Martin

©¿©¬

excel version?
2010

and how colored manually,
format cellsfill

conditonal formatting, macro??
don't know

Found it now Don
View code
--
Martin
©¿©¬