Forum Discussion
Is it possible to create a 4 colour scale with number ranges rather than gradient?
Yes, you can create a custom 4-color scale in Excel based on specific number ranges. Here's how you can set it up using Conditional Formatting:
- Select the Range: Select the cells where you want to apply the color scale. For example, if your blood pressure values are in column A from A1 to A100, select that range.
- Go to Conditional Formatting: Navigate to the "Home" tab on the Excel ribbon, click on "Conditional Formatting," and choose "New Rule."
- Choose Format Style: In the "Select a Rule Type" window, choose "Format cells that contain."
- Set Conditions:
- For the first condition (purple), select "Cell Value" in the first drop-down, choose "less than" in the second drop-down, and enter 90 in the third box. Click on the "Format" button, go to the "Fill" tab, and choose the purple color. Click "OK."
- Repeat this process for the other conditions (green, yellow/amber, and red) with the respective ranges and colors.
- Order the Rules: Make sure to order the rules correctly, from the lowest range to the highest, so that Excel applies the formatting in the intended order.
- Apply the Rules: Click "OK" in the "New Formatting Rule" window. Now, your selected range should have the custom 4-color scale applied based on the specified number ranges.
This way, the cells will be colored according to your defined ranges, making it easy to visualize your blood pressure levels at a glance. AI was partially deployed to support the text.
File with Examples included.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
Yes, you can create a custom 4-color scale in Excel based on specific number ranges. Here's how you can set it up using Conditional Formatting:
- Select the Range: Select the cells where you want to apply the color scale. For example, if your blood pressure values are in column A from A1 to A100, select that range.
- Go to Conditional Formatting: Navigate to the "Home" tab on the Excel ribbon, click on "Conditional Formatting," and choose "New Rule."
- Choose Format Style: In the "Select a Rule Type" window, choose "Format cells that contain."
- Set Conditions:
- For the first condition (purple), select "Cell Value" in the first drop-down, choose "less than" in the second drop-down, and enter 90 in the third box. Click on the "Format" button, go to the "Fill" tab, and choose the purple color. Click "OK."
- Repeat this process for the other conditions (green, yellow/amber, and red) with the respective ranges and colors.
- Order the Rules: Make sure to order the rules correctly, from the lowest range to the highest, so that Excel applies the formatting in the intended order.
- Apply the Rules: Click "OK" in the "New Formatting Rule" window. Now, your selected range should have the custom 4-color scale applied based on the specified number ranges.
This way, the cells will be colored according to your defined ranges, making it easy to visualize your blood pressure levels at a glance. AI was partially deployed to support the text.
File with Examples included.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
- Thank you so much, that worked perfectly.
