Help with conditional formatting

[Insomnia81]

Not sure this is possible and if not any idea how I could work around it?

Basically I have around 1000 rows of information and in one of the columns I have numbers 0-100. What I want to do is format cells 0-9 one color, 10-19 another, etc... I tried to do a formula if >X then format, but it supersedes the prior formulas so at the end of the day everything is just one color.

 

[dave2018]

Try:

=AND(condition 1,Condition 2)

in your example, replace condition 1 with: A1>=0

replace condition 2 with A1<=9

choose your custom format, and repeat for all your conditions!

 

[Peter_SSs]

Another option for your particular example is as follows, just using a single condition* for each section
The conditions need to end up in this order (they can be rearranged via Conditional Formatting -> Manage Rules) and each rule marked with the box 'Stop if True'.

I have only set up 3 of the rules but just continue the pattern.

* If there can be blank cells in the range that you don't want coloured, change the first rule only to =AND(E2<10,E2<>"")

Excel Workbook
	E
2	3
3	9
4	20
5	18
6	6
7	28
8	25
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2	1. / Formula is =E2<10	Abc
E2	2. / Formula is =E2<20	Abc
E2	3. / Formula is =E2<30	Abc