Posted to microsoft.public.excel.programming

luvgreen

external usenet poster

Posts: 33

How to know get the color index for the conditional formatting?

I want to know the color index for the current conditional formatting which
is true. How can I get the current condition color with VBA? I can only get
the real cell interior color and couldn't get the condition formatting color.
Please help. Thanks!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting on Index,Match formula	Nadine	Excel Worksheet Functions	3	May 1st 10 03:12 AM
Copying Color Index + conditional Formats + validation	Barb Reinhardt	Excel Programming	3	February 19th 07 07:20 PM
Color index & conditional format	Harley	Excel Programming	1	November 16th 06 01:11 PM
Conditional color formatting entries have wild color.	John Geyer	Excel Discussion (Misc queries)	0	February 24th 06 06:11 PM
Conditional Formatted Cell Color Index	MDR5300	Excel Programming	5	January 27th 05 09:15 PM

All times are GMT +1. The time now is 10:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us