S
shadym
Hi guys,
how to get the colorindex of a conditional formatted cells using a
macro?
how to get the colorindex of a conditional formatted cells using a
macro?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
shadym
I meant using VBA code.
A
Andy Pope
Hi,
Have a read of Bob Phillip's article on CF.
http://www.xldynamic.com/source/xld.CFConditions.html
Cheers
Andy
Have a read of Bob Phillip's article on CF.
http://www.xldynamic.com/source/xld.CFConditions.html
Cheers
Andy
S
shadym
thx for the quick reply Andy will read and post back
S
shadym
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.
cell instead of doing all this but this will make my script valid only
for this situation I wish there was an easier solution.
J
Jim Cone
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
Hi guys,
how to get the colorindex of a conditional formatted cells using a
macro?
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
Hi guys,
how to get the colorindex of a conditional formatted cells using a
macro?