|There are multiple ways to use the Conditional Formatting feature in Excel 2013. For the most part I still use the old school method of "formulas". Someone else might come along with a more modern way to accomplish your goal.|
If I was trying to do what you are asking for, I'd do it like this:
Let's assume you want to Conditionally Format a contiguous range of cells, e.g. A1:A10. (I'll explain how to CF a non-contiguous range later)
Let's further assume these values for your 3 criteria:
Less than 10 - Blue
10 through 20 - Red
Greater than 20 - Green
1 - Select A1:A10
2 - On the Home ribbon, click the Conditional Formatting
3 - Click New Rule
4 - Click "Use a formula to determine which cells to format"
5 - In the "Format values where this formula is true" enter:
6 - Click Format
7 - Click the Fill tab
8 - Click the Blue color
9 - "OK" your way out all the way back to the spreadsheet
With A1:A10 still selected, click Conditional Formatting
10 - Click Manage rules - you should see the rule you created earlier
11 - Click New Rule
12 - Click "Use a formula to determine which cells to format"
13 - In the "Format values where this formula is true" enter:
14 - Click Format
15 - Click the Fill tab
16 - Click the Red color
17 - Click OK twice
18 - Click New Rule
19 - Click "Use a formula to determine which cells to format"
20 - In the "Format values where this formula is true" enter:
21 - Click Format
22 - Click the Green color
23 - "OK" your way out all the way back to the spreadsheet
A1:A10 should now be Conditionally Formatted for those 3 criteria.
If you need to CF a non-contiguous set of cells with the same formats...
1 - Follow the instructions above for any one of the cells
2 - Copy the cell
3 - Ctrl-Click all of the other cells you want to CF
4 - Right-click any of those cells
5 - Choose Paste Special...Formats
You should be good to go.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.