| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to know get the color index for the conditional formatting?
Its not simple,
Vba Look here http://www.cpearson.com/excel/CFColors.htm UDF here http://www.vbaexpress.com/kb/getarticle.php?kb_id=190 Mike "luvgreen" wrote: 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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Thank you so much. This is very helpful!
Thank you so much. This is very helpful!
"Mike H" wrote: Its not simple, Vba Look here http://www.cpearson.com/excel/CFColors.htm UDF here http://www.vbaexpress.com/kb/getarticle.php?kb_id=190 Mike "luvgreen" wrote: 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!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Thank you so much. This is very helpful!
You can also find a color palette in the VBA help files under
PatternColorIndex Property that gives you the basic 56 colors with their corresponding indexnumbers. "luvgreen" wrote: Thank you so much. This is very helpful! "Mike H" wrote: Its not simple, Vba Look here http://www.cpearson.com/excel/CFColors.htm UDF here http://www.vbaexpress.com/kb/getarticle.php?kb_id=190 Mike "luvgreen" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting on Index,Match formula | Excel Worksheet Functions | |||
| Copying Color Index + conditional Formats + validation | Excel Programming | |||
| Color index & conditional format | Excel Programming | |||
| Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
| Conditional Formatted Cell Color Index | Excel Programming | |||
Hybrid Mode
