Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
pasting into an excel template without losing the formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |