Sort (find / replace) by cell colour ?
 

"Rob L" wrote in message
u...
Is it possible (excel 2000) to sort by colour (either background or text),
or to do a Replace based on colours ?

Thanks,

OM



Only by using code. Take a look he
http://www.cpearson.com/excel/SortByColor.htm

Sort (find / replace) by cell colour ?
 

http://xldynamic.com/source/xld.Colo...r.html#sorting

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Rob L" wrote in message
u...
Is it possible (excel 2000) to sort by colour (either background or text),
or to do a Replace based on colours ?

Thanks,

OM

Sort (find / replace) by cell colour ?
 

Is it possible (excel 2000) to sort by colour (either background or text),
or to do a Replace based on colours ?

Thanks,

OM