This can be achieved with the simple find and replace dialog box. This is how it is done;

1.Press [Ctrl] + [ F] to invoke the Find & Replace dialog box and then select the find tab.

2.With nothing in the Find What box, click on the Format button, which will open the format dialog box.

3.In the Format dialog box, go to the


Fill tab and then select the appro¬priate colour.

4.Click on OK to close the Format dialog and then choose Find All. The address of all the cells with that par¬ticular colour will be listed in the find and replace box.

5.Select one and then press [Ctrl] + [A] to select all other similar coloured cells.