See conditional formatting Color value in vba

  • Thread starter Thread starter Gunnar Sandström
  • Start date Start date
G

Gunnar Sandström

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
recognizing conditional formatting with VBA 3
Conditional Formatting with VBA 4
How to blank the colored cells? 0
Excel Macro to automatically go to the right of the last colored cell 0
conditional format - table - cell empty return default color 1
Excel conditional formatting with Weeknum 4
Conditional Formatting and VBA 4

Back
Top