| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ©¿©¬ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell colour on formula result change, no conditional format | Excel Programming | |||
| if cell colour is then change cell colour in range | Excel Programming | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
| Code to change interior colour only if current interior colour is | Excel Programming | |||
![Martin ©¿©¬[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
