how to tell if an excel cell has conditional formatting applied using VBA

excel vba conditional-formatting
yoshiserry picture yoshiserry · Jan 29, 2015 · Viewed 8.1k times · Source

I have a range of cells which have conditional formatting applied.

The aim was to visually separate the values with a positive, negative, and no change.

How can I use VBA to check if the cells have conditional formatting applied to them (such as color of the cell due to being a negative number)?

Answer

Gary's Student picture Gary's Student · Jan 29, 2015

See if the Count is zero or not:

Sub dural()
    MsgBox ActiveCell.FormatConditions.Count
End Sub

Related questions

Conditional Formatting using Excel VBA code

I have Range object called DistinationRange which contains reference to range B3:H63 I want to apply the following two conditional formatting rules using Excel VBA code dynamically. (Because the range would not be same all the time) If Cell …

Read More
Conditionally formatting cells if their value equals any value of another column

I have data in the A and B columns. B column's data is mostly duplicates of A's data, but not always. For example: A Budapest Prague Paris Bukarest Moscow Rome New York B Budapest Prague Los Angeles Bukarest I need …

Read More
Using VBA to apply conditional formatting to a range of cells

I would like to know how to access the column in conditional formatting titled 'Applies To' and input my own conditions. I have included a screenshot for better reference. My code for adding the syntax in conditional formatting is, With …

Read More