Determine in VBA if a cell has conditional formatting applied
 

Hi,

Is there a way to determine through VBA if a cell has conditional formatting
applied to it?

--
TIA
Chuck M.

Determine in VBA if a cell has conditional formatting applied
 

Try something like this:

ActiveCell.FormatConditions.Count 0

--
Jim
"Chuck M" wrote in message
...
| Hi,
|
| Is there a way to determine through VBA if a cell has conditional
formatting
| applied to it?
|
| --
| TIA
| Chuck M.

Determine in VBA if a cell has conditional formatting applied
 

Perfect! Thanks Jim.
--
Thanks.
Chuck M.


"Jim Rech" wrote:

Try something like this:

ActiveCell.FormatConditions.Count 0

--
Jim
"Chuck M" wrote in message
...
| Hi,
|
| Is there a way to determine through VBA if a cell has conditional
formatting
| applied to it?
|
| --
| TIA
| Chuck M.