How do I keep the format of a cell that an if statment refers to?
 

I'm using an if statemnt and the result if true points to one cell with
special formats and another cell if false with other formats. The result
shows the correct value, but I'm more interested in the font because I'm
using different symbols from various fonts.

Formulas return values--not formats.

Maybe you could use some other way--like a worksheet event that actually does a
copy|paste???

Gerardo wrote:

I'm using an if statemnt and the result if true points to one cell with
special formats and another cell if false with other formats. The result
shows the correct value, but I'm more interested in the font because I'm
using different symbols from various fonts.

--

Dave Peterson