conditional formatting test

S

Sunil Patel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Help 1
Conditional Formatting macro: simple, but doesn't work 6
Automation Ole Excel conditional formatting with PowerBuilder 9 0
Conditional Formatting and VBA 4
change font using conditional formatting 1
Overwrite conditional formatting 3
changing the color of a cell acording to its value 4
Excel Highlighting duplicates 0

Top