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