If the percent is never greater than 100%, then you could custom format the
font color. For example:

[Red][<1]0%;[Blue]$#.00

HTH
Jason
Atlanta, GA





"elad" wrote:

I have a cell that contains a formula that can yield either a dollar value or
a percentage value, depending on inputs. How can I format the cell to
correctly match the result?