How to check if cell has conditional formatting

's Computer Specifications

Is there a way to check if the active cell has any conditional
formatting?

's Computer Specifications

On Apr 1, 9:58*am, John <soundnee...@gmail.com> wrote:
> Is there a way tocheckif the active cell has any conditionalformatting?

Sorry....looks like this might work:
If range("A1").FormatConditions.Count >0

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 - check for blank cell	Eric_NY	Microsoft Excel Misc	3	18th Aug 2009 05:08 PM
Check if Conditional Format is True or False / Check cell Color	=?Utf-8?B?S2V2aW4gTWNDYXJ0bmV5?=	Microsoft Excel Worksheet Functions	5	29th Jun 2007 11:12 AM
conditional formatting via check box	cedtech23	Microsoft Excel Programming	1	20th Jul 2006 04:19 AM
check box conditional formatting	=?Utf-8?B?Si4gRGF2aXM=?=	Microsoft Access Reports	4	20th Apr 2006 12:35 AM
Check box & conditional formatting	=?Utf-8?B?QnJlbnQ=?=	Microsoft Excel Misc	4	10th Jan 2006 05:43 AM