| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating cells to display negative percentages in red fon...
How can I format cells to display negative percentages in red font?
Negative numbers can be displayed in red. Can this be done also for percentages |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating cells to display negative percentages in red fon...
The quickest way would be conditional formatting:) -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=520381 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating cells to display negative percentages in red fon...
Try typing this into the Format, Cells, Custom box: 0.00%;[Red]-0.00%
Hope this helps -- MarkN "Fast fred" wrote: How can I format cells to display negative percentages in red font? Negative numbers can be displayed in red. Can this be done also for percentages |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating cells to display negative percentages in red fon...
Worked very well.
Thanks, Mark "MarkN" wrote: Try typing this into the Format, Cells, Custom box: 0.00%;[Red]-0.00% Hope this helps -- MarkN "Fast fred" wrote: How can I format cells to display negative percentages in red font? Negative numbers can be displayed in red. Can this be done also for percentages |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| out of a group of cells, if max, then display this other cell | Excel Worksheet Functions | |||
| Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
| Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
| Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
Linear Mode
