Check this for how you can work on color set by conditional formatting in
XL2007..
http://www.xldynamic.com/source/xld.CFConditions.html#specific
Cheers!!
On Thu, Aug 7, 2014 at 6:56 AM, Daniel Parmet
wrote:
> I have a macro (first I've ever written!) that works wonderfully with
> cells that
Dan, you can get it yo work in Excel 2010 or above. There is a property
they introduced which will help to identity the actual interior color or
the color rendered by conditional format.
Regards
Sam
On 7 Aug 2014 06:57, "Daniel Parmet" wrote:
> I have a macro (first I've ever written!) that work