Can I use conditional formatting to scale a display value?

[mwrusso]

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.

 

[T. Valko]

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?

 

[mwrusso]

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?