Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default I need to change hardcoded background color

I have a spread sheet that has a background color that want to change but I
have tried all the traditional methods and none have worked is this some sort
of coding or script that won't allow me to remove the color.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default I need to change hardcoded background color

See your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bridgette Culpepper" <Bridgette wrote in message
...
I have a spread sheet that has a background color that want to change but I
have tried all the traditional methods and none have worked is this some sort
of coding or script that won't allow me to remove the color.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default I need to change hardcoded background color

What are the 'traditional methods' you've tried? If we know what you've
tried, then we won't suggest trying it again.

One non-traditional? method would be to choose all the cells on the sheet by
clicking the blank gray block just above the row 1 indicator and to the left
of the column A indicator, then choose Edit | Clear | Formats
Of course that means you'll have to go back into the worksheet and set up
things like currency, numeric and data formats all over again. You might
want to try that on a copy of the sheet before doing it to the real deal in
case it turns out to be an unacceptable solution.

"Bridgette Culpepper" wrote:

I have a spread sheet that has a background color that want to change but I
have tried all the traditional methods and none have worked is this some sort
of coding or script that won't allow me to remove the color.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change background color Chris Excel Discussion (Misc queries) 2 September 8th 06 02:32 PM
how can I conditionally change font color, or background color? MOHA Excel Worksheet Functions 3 August 21st 06 06:57 PM
change background row color with change of date in a cell Urszula Excel Discussion (Misc queries) 5 May 17th 06 07:56 AM
Change of text or background color doesn't change on the screen. Susan Excel Discussion (Misc queries) 5 July 29th 05 07:18 PM
Change background color Andrew Clark Excel Discussion (Misc queries) 3 March 16th 05 04:14 AM


All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"