Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default excel 2007 - change fill color from one color to another

in excel 2003 i could select an entire sheet, use the find/replace tool, and
find one color and replace with another color. in excel 2007, i can't seem
to be able to do this. am i missing something? i have a spreadsheet that
uses color in some cells and not in others. then when i create a new sheet,
i want the same cells filled with color and the same empty cells to remain
empty of color. but i want the color to be red instead of green (e.g.) for
the new sheet. how can i do this without specifically selecting every cell
or section of cells that is red and manually changing it to green. i used to
be able to use the "find format" function on the find/replace tool, but this
does not seem to work in 2007. HELP!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default excel 2007 - change fill color from one color to another

Ctrl/F with the Option button pressed and the Format button pressed and the
Choose Format from cell button pressed seems to work for me, same way as in
XL2003 -- what problem are you having? Is the sheet protected?

"okiedokiedoo" wrote:

in excel 2003 i could select an entire sheet, use the find/replace tool, and
find one color and replace with another color. in excel 2007, i can't seem
to be able to do this. am i missing something? i have a spreadsheet that
uses color in some cells and not in others. then when i create a new sheet,
i want the same cells filled with color and the same empty cells to remain
empty of color. but i want the color to be red instead of green (e.g.) for
the new sheet. how can i do this without specifically selecting every cell
or section of cells that is red and manually changing it to green. i used to
be able to use the "find format" function on the find/replace tool, but this
does not seem to work in 2007. HELP!!

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
fill color not working in excel 2007 lnel Excel Worksheet Functions 3 September 10th 07 12:56 PM
in excel, how do i change the fill color? [email protected] Excel Worksheet Functions 1 November 29th 05 07:33 PM
My fill color and font color do not work in Excel Std Edition 2003 chapstick Excel Discussion (Misc queries) 1 September 11th 05 08:48 PM
Excel 2003 will not display color fonts or color fill cells DaveC Excel Worksheet Functions 1 April 11th 05 04:38 PM
My excel 2003 wont let me fill cells with color or color the tabs. trizog New Users to Excel 2 February 22nd 05 07:43 PM


All times are GMT +1. The time now is 12:23 AM.

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"