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
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