| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
See conditional formatting Color value in vba
Hi!
what code do i use in vba to determin the background color of a cell caused by conditional formatting? When i use ex : bcolor = ActiveCell.Interior.ColorIndex bpcolor = ActiveCell.Interior.PatternColor i do not se the color caused by conditional formatting. \\\ Gunnar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
See conditional formatting Color value in vba
See
http://www.xldynamic.com/source/xld.CFConditions.html Testing CF Conditions -- HTH RP (remove nothere from the email address if mailing direct) "Gunnar Sandström" wrote in message ... Hi! what code do i use in vba to determin the background color of a cell caused by conditional formatting? When i use ex : bcolor = ActiveCell.Interior.ColorIndex bpcolor = ActiveCell.Interior.PatternColor i do not se the color caused by conditional formatting. \\\ Gunnar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting - color | Excel Discussion (Misc queries) | |||
| conditional formatting color | Excel Worksheet Functions | |||
| conditional formatting for tab color | Excel Worksheet Functions | |||
| Color Conditional Formatting | Excel Worksheet Functions | |||
| Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Hybrid Mode
