See conditional formatting Color value in vba
 

Hi!
what code do i use in vba to determin the background color of a cell caused
by conditional formatting?

When i use ex :
bcolor = ActiveCell.Interior.ColorIndex
bpcolor = ActiveCell.Interior.PatternColor
i do not se the color caused by conditional formatting.

\\\ Gunnar

See conditional formatting Color value in vba
 

See

http://www.xldynamic.com/source/xld.CFConditions.html
Testing CF Conditions

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gunnar Sandström" wrote in message
...
Hi!
what code do i use in vba to determin the background color of a cell
caused
by conditional formatting?

When i use ex :
bcolor = ActiveCell.Interior.ColorIndex
bpcolor = ActiveCell.Interior.PatternColor
i do not se the color caused by conditional formatting.

\\\ Gunnar