Carol, some of this depends on what you mean by "highlighted" and what you
want to do/mean by "pull".

Chip Pearson has done a world of work with dealing with cells that have
color applied to them ( hightlighted? ). These two pages give you some
information on that kind of thing, with the second page describing certain
things that you can do that he has provided functions for via a file to
download and use. While the first page indicates he's only talking about
sorting by color, it leads to more functions and is a good introduction to
what he provides on the second page listed below.

http://www.cpearson.com/excel/SortByColor.aspx
http://www.cpearson.com/excel/Colors.aspx


"Carol330" wrote:

I have a spreadsheet (50 pages). 4000 line entries. I have severaal hundred
highlighted. Is there a way to pull just the highlighted.