| 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) |
| 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) | |||
Threaded Mode
