Formating results

  • Thread starter Thread starter Roger Bedford
  • Start date Start date
R

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
 
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.
Click to expand...

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
 
You could define conditional formatting for the range of cells under
Format/Conditional Formatting...
 
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.
 
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



"Kevin Stecyk" said:
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.
Click to expand...

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
Click to expand...
 
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.
Click to expand...

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
 
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
 
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.
Click to expand...
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
 
Back
Top