Determine in VBA if a cell has conditional formatting applied

's Computer Specifications

Hi,

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

--
TIA
Chuck M.

's Computer Specifications

Try something like this:

ActiveCell.FormatConditions.Count > 0

--
Jim
"Chuck M" <(E-Mail Removed)> wrote in message
news:3858022A-98CF-4F71-9551-(E-Mail Removed)...
| Hi,
|
| Is there a way to determine through VBA if a cell has conditional
formatting
| applied to it?
|
| --
| TIA
| Chuck M.

's Computer Specifications

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

"Jim Rech" wrote:

> Try something like this:
>
> ActiveCell.FormatConditions.Count > 0
>
> --
> Jim
> "Chuck M" <(E-Mail Removed)> wrote in message
> news:3858022A-98CF-4F71-9551-(E-Mail Removed)...
> | Hi,
> |
> | Is there a way to determine through VBA if a cell has conditional
> formatting
> | applied to it?
> |
> | --
> | TIA
> | Chuck M.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Applied when Statement Not True	Deanna	Microsoft Excel Misc	6	23rd Sep 2009 04:14 PM
Can conditional formatting be applied to checkboxes?	MariahJ	Microsoft Access	3	10th Sep 2006 05:33 PM
can conditional formatting be applied in more then three instance	=?Utf-8?B?TWFyeSBqYW5l?=	Microsoft Excel New Users	2	21st Dec 2005 04:02 AM
How do I determine if conditional formatting is applied to an exc.	=?Utf-8?B?TWFya1RoZU51a2U=?=	Microsoft Excel Programming	17	16th Feb 2005 09:59 PM
Conditional formatting inconsistently applied	Robin	Microsoft Excel Worksheet Functions	1	2nd Apr 2004 04:40 AM