View Single Post
  #2   Report Post  
Dave Breitenbach
 
Posts: n/a
Default

If its only for negative vs positive numbers. Use a format with no colors in
the column and then use conditional formatting with 2 conditions - one for
negative numbers and one for positive numbers. (under format puuldown menu)

hth

"DrB" wrote:

Using number format custom to have my numbers come out green or red
depending upon + or - values. The green in [Green0%;Red0%] is too light. I
want to use dark green, but if I put that in it does not work. Is there a
way to get Dark Green to show up in above formatting?