How do conditional formatting for 5 conditions excel 2010

[palms]

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 textamount over $500 green text

Thanks for helping

[Simon H]

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.

[Jacks1496926423]

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.

 

Great Answer - you got my vote.