omg this is really hard I think I would better check the value of the
cell instead of doing all this but this will make my script valid only
for this situation I wish there was an easier solution.
wrote:
thx for the quick reply Andy will read and post back
Andy Pope wrote:
Hi,

Have a read of Bob Phillip's article on CF.
http://www.xldynamic.com/source/xld.CFConditions.html

Cheers
Andy

wrote:
I meant using VBA code.
wrote:

Hi guys,
how to get the colorindex of a conditional formatted cells using a
macro?