Posted to microsoft.public.excel.programming

Sunil Patel[_2_] Sunil Patel[_2_] is offline

external usenet poster

Posts: 4

conditional formatting test

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting - Test Practice	downinfl	Excel Discussion (Misc queries)	0	May 6th 10 10:49 PM
Conditional test	Abraham Zacharia	New Users to Excel	1	August 3rd 09 04:23 AM
Conditional formatting to test blank text cell	Andyjim	Excel Worksheet Functions	4	January 10th 08 08:45 PM
Conditional Formatting to Test Value in Cell	Carroll	Excel Worksheet Functions	3	March 9th 06 07:38 PM
Multiple-Test Conditional Formatting	BruceS	Excel Discussion (Misc queries)	4	May 30th 05 05:03 PM

All times are GMT +1. The time now is 11:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us