Color Reference

[chipgreenfield]

Hey guys,

Quick question. Is it possible to reference the color of a cell? Fo
example so all cells with red numbers can be extracted. Any help woul
be great. Thanks.

CHi

 

[Chip Pearson]

Chip,

You need to use VBA functions to get the color of a cell. See
www.cpearson.com/excel/colors.htm for more details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Don Guillett]

It depends on how the cells became colored.
Conditional formatting=use the same criteria you used to color
non-CF - Yes
Now, please explain "extracted"

 

[chipgreenfield]

Thanks Chip

Great Websit