如何使用vba在Excel 2007中找到有条件格式化单元格的填充颜色值？

I am using a colour scale for my conditional formatting in Excel 2007 and I am having a hard time finding out the fill colour code for the conditionally formatted cells. I know Interior.Color returns the default colour value but that does not help when using conditional formatting. I am relay quite surprised at how hard this has been to do. I am using a colour scale for my conditional fo