How do I write a custom format to make a negative percentage red

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a custom format that will make a negative percentage number
red but keep the positive numbers black.
 
You don't need a custom format. Use the menu Format | Conditional
Formatting.

Merjet
 
You could also use the builtin numberformat:

0.00%;[Red]0.00%;0.00%;@
or
0.00%;[Red]-0.00%;0.00%;@

positive;negative;0;text
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
number format 3
code to change color of negative cell 1
How to make a VBA Function return a value in percent format 8
Reverse color numeric formatting? 2
Formatting 8
How do I show negative percentage in a fomula? 1
Custom cell format for percentage 3

Back
Top