| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change the colour of numbers in a cell if the number is negative
In excell is it possible to change the colour of a number in a cell for
example if it goes negative? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the colour of numbers in a cell if the number is negative
Look at FormatConditional Formatting and the available Help.
-- Kind regards, Niek Otten Microsoft MVP - Excel "bryno" wrote in message ... | In excell is it possible to change the colour of a number in a cell for | example if it goes negative? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the colour of numbers in a cell if the number is negative
If you look at Format/ Cells/ Number/ Custom, you will see formats like
#,##0;[Red]-#,##0 and you can change them to suit your requirements. -- David Biddulph "bryno" wrote in message ... In excell is it possible to change the colour of a number in a cell for example if it goes negative? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the colour of numbers in a cell if the number is negative
FormatCellsNUmberNumberNegative Numbers.
Choose whatever option you wish. Gord Dibben MS Excel MVP On Wed, 5 Mar 2008 12:35:03 -0800, bryno wrote: In excell is it possible to change the colour of a number in a cell for example if it goes negative? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative and colour change | New Users to Excel | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| Change cell Colour when a number of days have been passed | Excel Discussion (Misc queries) | |||
| Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
| how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
Hybrid Mode
