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!! |
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!! |
All times are GMT +1. The time now is 12:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com