get conditional formatting color of a cell

**SP69** · 09-20-2013, 06:05 PM

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

**SP69** · 09-20-2013, 07:47 PM

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

**SP69** · 09-30-2013, 03:08 PM

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

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

Thread: get conditional formatting color of a cell