Formating results

[Roger Bedford]

I am using the following formula: ="("&fixed(s81/1000,0,true)&")"&"K"

I would like the result for negative 100 to be shown as (100)K with the number
and brackets in red but not the K. Results of 0 or any positive number should
all be in black. I am using Excel 5.

Any suggestions would be greatly appreciated.

Roger

 

[Kevin Stecyk]

Roger Bedford ...

I am using the following formula: ="("&fixed(s81/1000,0,true)&")"&"K"

I would like the result for negative 100 to be shown as (100)K with the number
and brackets in red but not the K. Results of 0 or any positive number should
all be in black. I am using Excel 5.

Any suggestions would be greatly appreciated.

Roger,

I can do the red brackets stuff, but not the black K. I do this by using
the custom format.

#,##0_)K;[Red](#,##0) K

If the result is positive or 0, brackets dissappear and numbers are black.

I got you part way to a solution. You might just have to settle for all red
or black, and not mixed. Let's see what others say.

Best regards,
Kevin

 

[P. Balmanno]

You could define conditional formatting for the range of cells under
Format/Conditional Formatting...

 

[P. Balmanno]

However this limits the format to color, If you Format/Cells/Number
"Negative Numbers" for a range of cells you can get black parenthesized
negative numbers.

 

[Roger Bedford]

Kevin, thanks to you and "P. Balmanno" for your suggestions. I've used yours
which is simpler than the other and will readdress the issue when I change to
Excel 2002 within the next year.

Roger

Roger Bedford ...

I am using the following formula: ="("&fixed(s81/1000,0,true)&")"&"K"

I would like the result for negative 100 to be shown as (100)K with the number
and brackets in red but not the K. Results of 0 or any positive number should
all be in black. I am using Excel 5.

Any suggestions would be greatly appreciated.

Roger,

I can do the red brackets stuff, but not the black K. I do this by using
the custom format.

#,##0_)K;[Red](#,##0) K

If the result is positive or 0, brackets dissappear and numbers are black.

I got you part way to a solution. You might just have to settle for all red
or black, and not mixed. Let's see what others say.

Best regards,
Kevin

 

[Kevin Stecyk]

Roger Bedford wrote in message...

Kevin, thanks to you and "P. Balmanno" for your suggestions. I've used yours
which is simpler than the other and will readdress the issue when I change to
Excel 2002 within the next year.

Roger,

I am glad that our suggestions were of benefit to you and thank you for
coming back to let us know. I am curious about your reference to XL 2002.
Is there some functionality in 2002 that lets you do what you want? I am
using XL 2003, so I am curious if I have overlooked something, which is
certainly possible.

Best regards,
Kevin

 

[Roger Bedford]

Hi Kevin, I just assumed that XL 2002 would have a lot more functionality
than Excel 5 from what I have seen. Some of it I like and some of it seems
more like useless bells and whistles. No doubt I will sort it out in due
course.

Roger

 

[Kevin Stecyk]

Roger Bedford wrote...

Hi Kevin, I just assumed that XL 2002 would have a lot more functionality
than Excel 5 from what I have seen. Some of it I like and some of it seems
more like useless bells and whistles. No doubt I will sort it out in due
course.

Hi Roger,

Okay, I am not sure if there is more functionality where you can change the
color "easily" of various parts of a format.

If there is some way, I am sure others will jump in and show us how.

Good luck.

Best regards,
Kevin