Find and Replace by Colour - 2007 - Wierd!

[preqin]

Open a new workbook in Excel 2007.

Change the cell colour to purple - the purple on the end of the 'standard colours' range.

Hit Ctrl H and change the format to purple, the replace to red, great it works.


Now. Move outside the standard colours range, choose the line of Orange colours (well, orange and peachy!)

The first (lightest) and last (darkest) colours work with a find and replace, all the colours inbetween DO NOT!

The exact same problem occurs on the next set of colours - the blue range. I've tried on a few others too and it seems the top and bottom are the only ones that work!!

Do others have this issue?!

 

[preqin]

Has anyone else tried this to see if they have the same problem?? - Would be good to know if I am on my own or if it's a common problem!