| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
How can I get text to be shown in red if the value is less than 0.00?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Microsoft Excel
Hi Andrew,
Format = Cells = Custom, and in the Type bar enter: "0.00_ ;[Red]-0.00" (without the quotation marks. Ewan. "Andrew1224" wrote: How can I get text to be shown in red if the value is less than 0.00? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enable automatic refresh | Excel Worksheet Functions | |||
| Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
| Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
| Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
| Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Linear Mode
