You're welcome. There's nothing similar for code. You could add a column
to the table, and use some of Chip Pearson's code for extracting colour
values. Then, filter on the new column.

http://www.cpearson.com/excel/SortByColor.htm

solomon_monkey wrote:
Thanks Debra... is there a similar simple code for filtering the colour
of a cell?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html