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