Conditional Formatting and VBA

's Computer Specifications

Is it possible to use VBA to return the font colour before and after a
condition is made?
ie. if the font colorindex changes from black to red? initial trials
suggest no?
any help appreciated.

's Computer Specifications

If you were controlling the change, then the answer is yes, but if you are
lookingt to trap such an event, then no.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is it possible to use VBA to return the font colour before and after a
> condition is made?
> ie. if the font colorindex changes from black to red? initial trials
> suggest no?
> any help appreciated.
>

's Computer Specifications

Bob Phillips wrote:
> If you were controlling the change, then the answer is yes, but if you are
> lookingt to trap such an event, then no.
>
Thanks Bob won't go down that road.

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 of text effecting formatting of background	=?Utf-8?B?SEFI?=	Microsoft Access Reports	6	25th Mar 2008 06:23 PM
Protect Cell Formatting including Conditional Formatting	=?Utf-8?B?TWljayBKZW5uaW5ncw==?=	Microsoft Excel Misc	5	13th Nov 2007 05:32 PM
Conditional Formatting No Longer Conditional in 2007 Beta	=?Utf-8?B?Q2FjdHVhci1Oby1KdXRzdQ==?=	Microsoft Excel Crashes	0	17th Nov 2006 10:01 PM
How do I do a complex conditional in a conditional formatting formula	Ray Stevens	Microsoft Excel Discussion	7	12th Mar 2006 10:24 PM
Conditional Formatting that will display conditional data	=?Utf-8?B?QnJhaW5GYXJ0?=	Microsoft Excel Worksheet Functions	1	13th Sep 2005 05:45 PM