How to add more than 3 col

Koalafied 

To add more than three colors to your color scale for conditional formatting in Excel, as noted by Mr. Jan Karel Pieterse in his message, you can use a custom formula.

Here is how you can achieve it:

1. Select the range of cells you want to apply the conditional formatting to.
2. Go to the "Home" tab in the Excel ribbon and click on the "Conditional Formatting" button.
3. Choose "Color Scales" and select the option "More Rules" at the bottom of the menu.
4. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format" option.
5. In the "Format values where this formula is true" field, enter the following formulas for each category:

95-100%: =AND(A1>=0.95,A1<=1)

90-95%:   =AND(A1>=0.9,A1<0.95)

85-90%:   =AND(A1>=0.85,A1<0.9)

80-85%:   =AND(A1>=0.8,A1<0.85)

75-80%:   =AND(A1>=0.75,A1<0.8)

<75%:      =A1<0.75

Note: Replace A1 with the cell reference of the first cell in your selected range.

1. Click on the "Format" button to choose the formatting style for each category. You can select the desired fill color, font color, and other formatting options.
2. Repeat steps 4-6 for each category, adjusting the formulas and formatting as needed.
3. Click "OK" to apply the conditional formatting rules.

By using custom formulas, you can create up to six categories with different colors for each range of values.