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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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


"chipgreenfield" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hey guys,
>
> Quick question. Is it possible to reference the color of a cell? For
> example so all cells with red numbers can be extracted. Any help would
> be great. Thanks.
>
> CHip
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

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"

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"chipgreenfield" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hey guys,
>
> Quick question. Is it possible to reference the color of a cell? For
> example so all cells with red numbers can be extracted. Any help would
> be great. Thanks.
>
> CHip
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

Thanks Chip

Great Websit

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com