ExcelBanter - select by color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - select by color (https://www.excelbanter.com/excel-discussion-misc-queries/45575-select-color.html)

Kristin N

select by color

How can I select specific cells that have been colorized. Once selected I
want to move these to a different column.

Bill Martin

Kristin N wrote:
How can I select specific cells that have been colorized. Once selected I
want to move these to a different column.

Chip Pearson has a bunch of functions to handle colored cells:

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

Bill

All times are GMT +1. The time now is 06:35 AM.