Allow conditional formatting rules to change the ACTUAL font color of a cell.
When I use conditional formatting to change the color of the text inside a particular cell or cells, it works to the extent that I see the new color on my screen, but when I go to the immediate window of VBA and ask Excel what the font color of that cell is using range().font.colorindex, it gives me 1, meaning the ACTUAL font color didn't change. Because of this, I can't code for the color of this cell in VBA, which is what I'm trying to do. The way I have things set up, a certain cell could contain a different color of text (conditionally formatted based on the text) every time the sheet is calculated, and I want to be able to run a macro that understands what color the cell's font was changed to. I can't do this because my macro thinks the font color didn't even change at all. I think you should consider allowing conditional formatting rules to change the ACTUAL attributes of the cells that are formatted so that VBA can recognize the change. If you choose not to do this for me, could you at least me know how I can work around my problem? Thanks.