<div>
yws812,<br />
Thanks for the grade!<br />
Brad
</div>


<div>
<div class="content wysiwyg-content">
I have a set of cells<br />
<br />
5 &nbsp; 3 &nbsp; 8 &nbsp; 2 &nbsp;-6 &nbsp; 4 &nbsp; 3 &nbsp;-2<br />
<br />
I have set a condition formatting to set any negative values to green (colorindex of 4) so the cells in brackets would show up green<br />
<br />
5 &nbsp; 3 &nbsp; 8 &nbsp; 2 &nbsp;[-6] &nbsp; 4 &nbsp; 3 &nbsp;[-2]<br />
<br />
however, when i try to get the cells(r,c).interior.colori<wbr />ndex, it still gives me clear althought the conditional formatting shows it as green.<br />
<br />
myColor = cells(r,c).interior.colori<wbr />ndex &nbsp; &nbsp; &nbsp;(myColor becomes value -4142 which is clear)<br />
<br />
How do i get the value of the conditional formatting color and not just the cell color of that cell.
</div>
</div>


I have a set of cells

5   3   8   2  -6   4   3  -2

I have set a condition formatting to set any negative values to green (colorindex of 4) so the cells in brackets would show up green

5   3   8   2  [-6]   4   3  [-2]

however, when i try to get the cells(r,c).interior.colorindex, it still gives me clear althought the conditional formatting shows it as green.

myColor = cells(r,c).interior.colorindex      (myColor becomes value -4142 which is clear)

How do i get the value of the conditional formatting color and not just the cell color of that cell.

EXCEL VBA: color index from conditional formatting

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.