View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MarkN
 
Posts: n/a
Default 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