Solved changing font colour using vba

April 10, 2015 at 02:57:33
Specs: Windows 7
I have a number of cells whre the font colour is changed by conditional formatting but these changes are not recognised when using vba. How can i resove this situation

See More: changing font colour using vba

Report •


#1
April 10, 2015 at 04:59:46
✔ Best Answer
Your subject line doesn't seem to match the text in your post.

Do you want to change the font color using VBA (subject line) or do you want to recognize the CF color using VBA (text in post)?

If you want to recognize the font color set by CF, try something like this:

MsgBox Cells(1, 1).DisplayFormat.Font.ColorIndex

I don't know what you are trying to accomplish, but perhaps checking the value of the cells that the CF is applied to might be easier than checking the font color set by CF.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question