You can even use a UserDefined Function that can return the colorindex.

Chip Pearson has a nice function at:
http://www.cpearson.com/excel/colors.htm

Returning The ColorIndex Of A Cell

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

MalibuinthePeg wrote:

Can you filter or sort by the formatting of a cell - these were formatted
manually and do not have conditional formatting applied to them - thanks

--

Dave Peterson