Formatting cells in Excel for certain Values to appear certain Col
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) |
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) |
I was close then, thanks for the help. (worked perfectly)
"Frank Kabel" wrote: 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) |
All times are GMT +1. The time now is 08:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com