Can I use conditional formatting to scale a display value?
 

I have a value in a cell, I would like to display the value directly with a
text modifier if it is above a certain threshold or display a scaled value
with a different text modifier if it is below a threshold. I use the value
in a different calculation so I don't want to change the value of the cell,
only the way it displays.

Examples:
If the value is time:
..5 should read as "4 hours" while 2 should read as "2 days"

If it was money:
..5 should read as "50 cents" while 2 should read as "2 dollars"

Thanks.

Can I use conditional formatting to scale a display value?
 

I don't see how this would be possible.

How would Excel know whether .5 is supposed to be hours or cents or whether
2 is supposed to be days or dollars?

--
Biff
Microsoft Excel MVP


"mwrusso" wrote in message
...
I have a value in a cell, I would like to display the value directly with a
text modifier if it is above a certain threshold or display a scaled value
with a different text modifier if it is below a threshold. I use the
value
in a different calculation so I don't want to change the value of the
cell,
only the way it displays.

Examples:
If the value is time:
.5 should read as "4 hours" while 2 should read as "2 days"

If it was money:
.5 should read as "50 cents" while 2 should read as "2 dollars"

Thanks.

Can I use conditional formatting to scale a display value?
 

I was hoping I could use the custom format types. I know you can use
conditionals to display different numbers or text:
[<=1]0.##;[1]#.#;General
or
[<=1]0.## " hours";[1]#.# " days";General

I was hoping something like this would work:
[<=1]0.## *8 " hours";[1]#.# " days";General

Where "*8" would scale the display value, but of course that just makes 8
repeat to fill the cell.

Maybe it's not possible?



"T. Valko" wrote:

I don't see how this would be possible.

How would Excel know whether .5 is supposed to be hours or cents or whether
2 is supposed to be days or dollars?

--
Biff
Microsoft Excel MVP


"mwrusso" wrote in message
...
I have a value in a cell, I would like to display the value directly with a
text modifier if it is above a certain threshold or display a scaled value
with a different text modifier if it is below a threshold. I use the
value
in a different calculation so I don't want to change the value of the
cell,
only the way it displays.

Examples:
If the value is time:
.5 should read as "4 hours" while 2 should read as "2 days"

If it was money:
.5 should read as "50 cents" while 2 should read as "2 dollars"

Thanks.