login about faq

it only let me do 3 conditions. I am want my column like this

all amount less than $0 in red text $0 to $100 orange text $101 to $250 yellow text $251 to $500 blue text amount over $500 green text

Thanks for helping

asked May 03 '12 at 08:15

palms's gravatar image


You can only set 3 conditions but to work around this

First, when you format the cells to Dollars choose the option to have negative numbers in red, this takes care of the amounts less than $0.

Next use conditional formatting for $0 to $100, $101 to $250 and $251 to $500

All that’s left is amounts over $500 so select all the cells in the column and in the fonts group on the home tab select green for font colour. Any cells not matching the conditional formatting criteria will now have green text, In this case that will be those amounts over $500.


answered May 04 '12 at 18:02

Simon%20H's gravatar image

Simon H

Great Answer - you got my vote. ;)

(May 06 '12 at 15:36) Jacks Jacks's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:
    [text](http://url.com/ "title")
  • image:
    ![alt text](/path/img.jpg "title")
  • numbered list:
    1. Foo
    2. Bar
  • Code:
    • Within a paragraph:
      surround code with grave accents (backticks)
    • Code snippet:
      Select the text and use the button on the icon of zeros and ones
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: May 03 '12 at 08:15

Seen: 2,323 times

Last updated: Jun 13 '12 at 01:21

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact