conditional formatting test

's Computer Specifications

I have a cell where font is black, but due to conditiona formatting the font
color is white. How do i test if font is white due to conditional
formatting.
I am trying
If ActiveCell.ColorIndex = 3 Then End

This does not work

Sunil

's Computer Specifications

see your other post

"Sunil Patel" wrote:

> I have a cell where font is black, but due to conditiona formatting the font
> color is white. How do i test if font is white due to conditional
> formatting.
> I am trying
> If ActiveCell.ColorIndex = 3 Then End
>
> This does not work
>
> Sunil
>
>
>

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 - Test Practice	downinfl	Microsoft Excel Misc	0	6th May 2010 10:49 PM
Conditional formatting -can I test for emptiness?	Laurel	Microsoft Access Forms	5	7th Jun 2009 05:18 AM
Conditional formatting to test blank text cell	Andyjim	Microsoft Excel Worksheet Functions	4	10th Jan 2008 08:45 PM
Conditional Formatting to Test Value in Cell	Carroll	Microsoft Excel Worksheet Functions	3	9th Mar 2006 07:38 PM
Multiple-Test Conditional Formatting	=?Utf-8?B?QnJ1Y2VT?=	Microsoft Excel Misc	4	30th May 2005 05:03 PM