I have columns in excel that get formatted based on conditiona
formatting.

e.g. if cell G1 contains "1" then cell g2 is changed from bein
automatic colour to being Blue text on grey background.

The Blue text is colorindex 5.

However if the conditional formatting is applied and I select the cel
in the VB code the activecell.font.colorindex still returns the defaul
colour rather than the current formatted colour.

I need to check if the cell is a different font and if so skip it so i
there any way to get the font with the conditional formatting ?

Regards
Bria

--
wardide
-----------------------------------------------------------------------
wardides's Profile: http://www.excelforum.com/member.php...fo&userid=1502
View this thread: http://www.excelforum.com/showthread.php?threadid=27730