conditionally format cells

E

elad

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?
 
J

Jason Morin

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
 
R

RagDyeR

Since you didn't state examples, try this custom format, where you'll
*never* have a return of 100%:

[>=1]$#,###.00;[<1]#.0%;General

If you anticipate a return of 100%, try this, where you'll lose the ability
to display $1:

[>1]$#,###.00;[<=1]#.0%;General
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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?
 
Top