View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
wrong order in your custom format :-)
Try:
[Blue]#,##0.0;[Red](#,##0.0);[White]#,##0.0

--
Regards
Frank Kabel
Frankfurt, Germany

Lucius wrote:
I want the positive cells to appear in Blue, the negetive cells in
Red and in paranthesis, the cells that equal zero are in white.

There is an unwanted negative sign apperearing, how do I get rid of
it? This is what I've got so far;
[Blue]#,##0.0;[White][=0]#,##0.0;[Red](#,##0.0)