VBA Conditional formatting

  • Thread starter Thread starter Steven E.
  • Start date Start date
S

Steven E.

I can change the conditional formats of cells with the
FormatConditions Object. But is it possible to get the conditional
formats from a cell in Excel to show them in VBA
 
You should be able to just reverse the statement. Instead of

Selection.FormatConditions(1).Interior.ColorIndex = 52

use

nn = Selection.FormatConditions(1).Interior.ColorIndex

Is this what you are trying to get?
 
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
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Highlighting duplicates 0
What does Conditional format change when highlighting? 5
Excel Macro to automatically go to the right of the last colored cell 0
Excel 2007 - A Conditional Formatting ?'s 1
Help needed 0
Excel Conditional Formatting Removal 7

Back
Top