Create Four Discrete Blood Pressure Colors with Excel Conditional Formatting
Question details
Create separate Excel conditional-formatting rules that apply fixed fill colors to four blood pressure ranges rather than a gradient color scale.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants blood pressure values in a selected worksheet range to display a discrete color based on defined thresholds.
- Observed behavior
- Each value should receive a purple, green, amber, or red fill according to its blood pressure range.
Confirm that the blood pressure cells contain numeric values, not text. Decide how values at the exact boundaries and any decimal gaps, such as 90.0 to 90.4, should be classified before creating the rules.
Create four fixed blood pressure conditional-formatting rules in Excel
Use individual “Format only cells that contain” rules when each blood pressure range needs one solid, discrete fill color.
This approach replaces a color scale with independent threshold rules. Apply the rules to the full blood pressure data range so new or updated values are formatted consistently.
Select the cells containing the blood pressure values, for example B2:B100. On the Home tab, select Conditional Formatting > New Rule.
Choose Format only cells that contain. Set Cell Value to less than 90, select Format > Fill, choose purple, and select OK.
Open Home > Conditional Formatting > New Rule again. Choose Format only cells that contain, set Cell Value to between 90.5 and 119.5, then choose a green fill.
Create another rule with Format only cells that contain. Set Cell Value to between 120 and 134.5, then select an amber or yellow fill.
Create a final rule for Cell Value greater than or equal to 135 and choose a red fill. Go to Home > Conditional Formatting > Manage Rules to confirm that all rules apply to the intended range and that overlapping rules are ordered correctly.

Apply Discrete Blood Pressure Color Rules in WPS Spreadsheets
WPS Spreadsheets lets you create separate conditional-formatting rules for blood pressure thresholds, using fixed fills instead of a gradient. Select your data range, add rules for each value band, and manage the rules from a familiar spreadsheet interface.
- 1. Select the blood pressure range: In WPS Spreadsheets, select the cells that contain the blood pressure readings.
- 2. Open conditional formatting: Go to Home > Conditional Formatting and choose New Rule or Add Rule.
- 3. Create the low-value rule: Set the condition to Cell Value less than 90, then choose a purple fill format.
- 4. Add the remaining value bands: Add rules for 90.5 through 119.5 with green, 120 through 134.5 with amber, and 135 or greater with red.
- 5. Review the applied range and conditions: Open Conditional Formatting > Manage Rules to verify the Applies to range and adjust any boundary values that should not remain unformatted.

Frequently Asked Questions
Why should I use separate rules instead of a color scale for blood pressure values?
A color scale creates gradual shades based on the data distribution. Separate rules create fixed, predictable colors for each clinical or reporting threshold.
How do I change the fill color for an existing Excel conditional-formatting rule?
Select a cell in the formatted range, then go to Home > Conditional Formatting > Manage Rules. Select the rule, choose Edit Rule > Format > Fill, choose the new color, and select OK.
What happens if a blood pressure value does not match any of the four rules?
It receives no conditional fill. With the listed thresholds, values such as 90.0 through 90.4 may be unformatted, so revise the rule limits if those decimal values can occur.
Do conditional-formatting rules work when I add more rows in Excel?
They work for cells included in the rule's Applies to range. Open Home > Conditional Formatting > Manage Rules and expand the Applies to range, or format the data as an Excel table so new rows can inherit the setup.
Can WPS Spreadsheets open an Excel file with these conditional-formatting colors?
Yes. WPS Spreadsheets supports Microsoft Excel .xlsx and .xls files and can open, review, and edit standard cell-based conditional-formatting rules.




