<div>
Hello SOUTHAMERICA70,<br />
<br />
Chip Pearson has numerous code examples showing<br />
how to evaluate cell colors.<br />
<br />
If the coloring is due to &quot;normal&quot; formatting:<br />
<br />
<a href="http://www.cpearson.com/excel/colors.htm" rel="ugc">http://www.cpearson.com/excel/colors.htm</a><br />
<br />
If the coloring is from Conditional Formatting:<br />
<br />
<a href="http://www.cpearson.com/excel/CFColors.htm" rel="ugc">http://www.cpearson.com/excel/CFColors.htm</a><br />
<br />
<br />
Regards,<br />
<br />
Patrick
</div>


Hello SOUTHAMERICA70,

Chip Pearson has numerous code examples showing
how to evaluate cell colors.

If the coloring is due to "normal" formatting:

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

If the coloring is from Conditional Formatting:

http://www.cpearson.com/excel/CFColors.htm [http://www.cpearson.com/excel/CFColors.htm]


Regards,

Patrick

cc.xls

<div>
Dave,<br />
<br />
Brilliant!<br />
<br />
Patrick
</div>


<div>
thx Patrick, I had missed your earlier post <br />
<br />
although new Excel security updates now flag XLM use, so the invisible macro is getting hard to use :)<br />
<br />
Dave<br />

</div>


thx Patrick, I had missed your earlier post

although new Excel security updates now flag XLM use, so the invisible macro is getting hard to use :)

Dave


<div>
Quick question...how do I use XLM?
</div>


<div>
It is used automatically by the range name, ie the<br />
=GET.CELL(63,A1<br />
portion is using a XLM formula to retrieve the cell backgrund colour (63 is the colour code)<br />
<br />
Cheers<br />
Dave<br />

</div>


It is used automatically by the range name, ie the
=GET.CELL(63,A1
portion is using a XLM formula to retrieve the cell backgrund colour (63 is the colour code)

Cheers
Dave


<div>
Got it. &nbsp;Thanks. &nbsp;Also I created a new excel sheet but when I place the &nbsp;=CellColour+RAND()*0 in the cell I get a #NAME? error.
</div>


Got it.  Thanks.  Also I created a new excel sheet but when I place the  =CellColour+RAND()*0 in the cell I get a #NAME? error.

<div>
<div class="content wysiwyg-content">
Want i'm trying to accomplish is:<br />
In column A I have multiple cells with different colors in them in column B I wanted the color index of each colored cell, for example.<br />
If column A cell A1 is red I wanted in column B, B1 to display 3 and so on.
</div>
</div>


Want i'm trying to accomplish is:
In column A I have multiple cells with different colors in them in column B I wanted the color index of each colored cell, for example.
If column A cell A1 is red I wanted in column B, B1 to display 3 and so on.

Displaying the color index of a cell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.