In addition to Saruman's suggestion.

After hitting the Find All button as instructed below, in the Found Dialog Box
you can hit SHIFT + End to select all found cells and apply formatting to all at
once if desired.


Gord Dibben MS Excel MVP


On Thu, 14 Feb 2008 00:01:06 -0000, "Saruman" wrote:

In Excel 2003, you can use the find Tab of Find And Replace to locate
coloured cells.

Open a find and replace form

Leave the Find What: field blank

Click the options button

Click the dropdown arrow on the Format Button

Select the Choose Format From Cell option

Now click in a cell with the format that you want to amend

Click the Find All Button and cells with that formatting are shown in the
lower window.

Click each one to go to that cell and make format changes as required in
each cell.

Hope this helps!

--
Saruman