PC Review


Reply
Thread Tools Rate Thread

conditional formatting test

 
 
Sunil Patel
Guest
Posts: n/a
 
      26th Mar 2009
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


 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      26th Mar 2009
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
>
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:53 PM.