View Single Post
  #10   Report Post  
Steve
 
Posts: n/a
Default

"RagDyer" wrote:
Ok, thanks, that explains it (posted my last message before I saw this
explanation). Of course, it would be nice if there was some kinda
warning or explanation when choosing that cell format option. And
even better if the status bar was capable of showing the color red.


One reason I like to use plain red is that it makes the numbers easier
to read, without the parentheses. A second-best option would be red
with a negative sign. But that doesn't appear to be possible...


You can create a custom format to show almost *anything* you want.
Custom format for red and minus sign:
#,##0.00;[Red]-#,##0.00
And of course, you could add the parenthesis also:
#,##0.00_);[Red](-#,##0.00)


Thanks, I'll give those a try. What I'd really like to be able to
customize is the status bar, to show the color red or use the minus
sign even though I haven't used it in the cells...