How did the font get formatted?

By CF? Use the same condition to return a text string.

My manual format? You will need VBA to determine index number of font
format.


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 08:13:01 -0700, Steve
wrote:

I want to return a text string based on font formats. Is this possible?