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

I meant using VBA code.
wrote:
Hi guys,
how to get the colorindex of a conditional formatted cells using a
macro?

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?

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?

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?

For what it's worth (no code available) ...
There is the free Excel add-in "Determine Colors" that reads the active cell's
colors and displays the result on the right-click menu.
It works for regular and conditionally formatted colors and provides the
font, interior, pattern and border colors plus the tab color.

It was written to possibly help color-blind Excel users.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


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