Wow -- I was hoping someone knew an easy way to this. I didn't know that you
could put those sorts of conditions in a format!

Art

"MrShorty" wrote:

>
> Something like this: [<10]0.0" GHz";0" MHz" will display any number <10
> as "x.x GHz" and anything >10 will be displayed as "xxx MHz"
>
> You didn't say what to do with values between 10 and 100, so I left
> those to be formatted as "xx MHz" but you could add another condition
> to do something different with those values.
>
> This works for a limited number of categories (up to three or four, I
> think). Play around with it and see if it helps.
>
>
> --
> MrShorty
> ------------------------------------------------------------------------
> MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
> View this thread: http://www.excelforum.com/showthread...hreadid=505421
>
>