View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sunil Patel[_2_] Sunil Patel[_2_] is offline
external usenet poster
 
Posts: 4
Default 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