From: "Peter Beach" References: <271019991409034475%derekd@badxmission.com> Subject: Re: Detecting conditional formatting changes with VBE Date: Thu, 28 Oct 1999 08:48:13 +0100 Lines: 48 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Message-ID: Newsgroups: microsoft.public.excel.programming NNTP-Posting-Host: p4ds13a08.client.global.net.uk 195.147.93.78 Path: cppssbbsa01.microsoft.com!cppssbbsa05 Xref: cppssbbsa01.microsoft.com microsoft.public.excel.programming:93073 Uwe, I think the answer to the question is "no" :-( There was a thread on this subject a while back and IIRC no-one found out a way of finding what conditional formatting was active in a cell. You can find out what the formula conditions are. Check out the following: Sub CheckFmt() dim r As range dim i As Integer set r = activecell for i = 1 to r.formatConditions.count Debug.Print r.formatConditions(i%).formula1 Debug.Print r.formatConditions(i%).Operator next i end Sub You may be able to play around with something based on this (plus the cell's .value property) to determine which format condition (if any) has been applied. for example .Operator is 5 for a greater than test and formula1 contains the condition (e.g. 100) to apply against the test. HTH Peter Beach Excel MVP Uwe Denk wrote in message news:271019991409034475%derekd@badxmission.com... > > Is there a way to detect whether a conditional format a has taken > effect in a cell. for instance, I have set the limit within a cell to > a specific value and if that set value is reached, the color of the > text changes to red. The original color was black. When checking the > color of the cell; either before or after the color change has taken > effect with ²activecell.font.color²; the result is always ³0². > > -- > Uwe Denk > derekd@xmission.com > http://www.xmission.com/~derekd > This message was sent using the MacOS.