code to change color of negative cell

  • Thread starter jacquelineholliday
  • Start date
J

jacquelineholliday

I am creating a table with percentages and I want it to make the
negative %s red. How would I code/format for this?

Thanks,
Jackie
 
T

Tom Ogilvy

do a custom number format (format=>cells=>Number Tab then Custom)

0.0%;[Red]0.0%
 

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

Program buttons to create a word document 0
Fill color if amount is negative 1
Reverse color numeric formatting? 2
Need help modifying code 0
Fill tringle in a cell with color 1
Using minus values in conditional formatting 1
negative currency abbreviated format 1
Match table shading (color) to Visio color/Transparency 1

Top