Formatting Issues

Create Four Discrete Blood Pressure Colors with Excel Conditional Formatting

Kushani NimanthikaKushani Nimanthika Nov 12, 2026 868 views

Question details

Create separate Excel conditional-formatting rules that apply fixed fill colors to four blood pressure ranges rather than a gradient color scale.

Create Four Discrete Blood Pressure Colors with Excel Conditional Formatting
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the blood pressure cells

Select the cells containing the blood pressure values, for example B2:B100. On the Home tab, select Conditional Formatting > New Rule.

2
Add the purple low-value rule

Choose Format only cells that contain. Set Cell Value to less than 90, select Format > Fill, choose purple, and select OK.

3
Add the green range rule

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.

4
Add the amber range rule

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.

5
Add the red high-value rule and review order

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.

Create four fixed blood pressure conditional-formatting rules in Excel
Check decimal boundaries: The specified ranges leave values from 90.0 to 90.4 and 119.6 to 119.9 without a color. If those values are possible, adjust the limits, such as using 90 to 119.99 and 120 to 134.99, based on your data precision.
Conditional formatting in WPS Spreadsheets

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. 1. Select the blood pressure range: In WPS Spreadsheets, select the cells that contain the blood pressure readings.
  2. 2. Open conditional formatting: Go to Home > Conditional Formatting and choose New Rule or Add Rule.
  3. 3. Create the low-value rule: Set the condition to Cell Value less than 90, then choose a purple fill format.
  4. 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. 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.
Create solid purple, green, amber, and red fills for blood pressure thresholds.Set precise less-than, between, and greater-than-or-equal-to conditions.Open and edit Microsoft Excel .xlsx and .xls workbooks with formatting compatibility.Use a free, lightweight spreadsheet app with familiar worksheet tools.
microsoft office alternative - wps office

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.