get conditional formatting color of a cell

VBA: Need to get color of cell with conditional formatting. Tried post by Rick Rothstein in the forum but it didn't work. I referred to :

Code:

---

http://www.excelfox.com/forum/f22/get-displayed-cell-color-whether-from-conditional-formatting-or-not-338/

---

Attaching the image of conditional formatting used by me [ Excel 2010]

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

got that by myself.... its the activecell.displayformat.interior.color

this works for 2010 only...can anybody help me with this in 2007??


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA