Remove colour change
 

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
©¿©¬

Remove colour change
 

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? and how colored manually, conditonal formatting, macro??

Remove colour change
 

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

Remove colour change
 

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
©¿©¬

Remove colour change
 

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

©¿©¬

Send your file to dguillett1 @gmail.com