How to find colorA and replace it with colorB?

I have Excel MAC 2011 and my spreadsheet was created with multiple cell colors randomly throughout the spreadsheet.

I need to change all the royal blue colored cells to "no color" without changing the data contained in the cell. For example; Cells A5:A38 are blue, A39 is green, A40:A50 blue, A51:60 green, ... Cells B5:B15 are grey, B16:B20 are blue, B21 is yellow...

I can't find the "Advanced Options" for Find and Replace that might have allowed me to specify a color change.

Solutions? Ideas?

See if this works..

Select the range you want to change the color. Go to find and replace.
leave blank on "find what".
click format adjacent to "find what". select the royal blue from the fill tab ( make sure are selecting correct color, else excel would say nothing to find)

leave blank on " replace with"
click format adjacent to "replace with". select no color in the fill tab.

Click Replace all. Done

I would LOVE that to work, and it is available on my Windows 2010 Excel, but MAC 2011 doesn't have the format option in the find and replace.

Do you know someone who has a MAC and 2011 Excel and knows where the format would be for find and replace?

Thanks for trying.
Linda

Sorry for that.. i never knew excel in mac doesn't have the option.
Will get back if my friend who uses excel in mac, replies me back.

Originally Posted by elayaz

Sorry for that.. i never knew excel in mac doesn't have the option.
Will get back if my friend who uses excel in mac, replies me back.

Thank you! For now I changed it by hand, but there must be a way! Microsoft never stops a process, but sometimes they hide it really well!