View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default conditional formatting test

Hi,

To test the font colour use

MyColour = ActiveCell.Font.ColorIndex

But this won't return the font colour if that colour is set by conditional
formatting. It can be done and I recall there is a method on the XLdynamic
web site but it's not easy.

Why don't you test for the condition that causes the format colour white
from which you can infer the colour of the font.

Mike

"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