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.