Return Conditional Format Color

Hello all,

I am using conditional formatting to display a color gradient across a range of cells, and want to use some VBA code to return the color of each cell in hex format. I tried applying the method shown on this site: Conditional Formatting Colors , but the functions return invalid. After some investigation, it seems VBA does not recognize the FormatCondition object, and thus, cannot retrieve its formula. Is this a 2010 bug? Does anyone know some other way to return the color from conditional formatting?

Thanks!

Does anyone have an idea? Should I just let it go?

See http://www.cpearson.com/excel/CFColors.htm

That's the exact link I posted above...