Formating cells to display negative percentages in red fon...

[Fast fred]

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>

[davesexcel]

The quickest way would be conditional formatting

[MarkN]

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>

[Fast fred]

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>