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.

T
Thu May 08 21:52:31 CDT 2008

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" <mwrusso@discussions.microsoft.com> wrote in message
news:1FBD15AC-290A-4B9E-B16A-871EBD1182F4@microsoft.com...
>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.

mwrusso
Fri May 09 14:18:03 CDT 2008

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" <mwrusso@discussions.microsoft.com> wrote in message
> news:1FBD15AC-290A-4B9E-B16A-871EBD1182F4@microsoft.com...
> >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.
>
>
>