excel 2007 - change fill color from one color to another

[okiedokiedoo]

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!!

 

[Bob Umlas, Excel MVP]

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?