|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.