Jan 26 2024 08:05 AM
I am trying to keep track of my blood pressure and want to make it easy to look at with a glance.
Idealy I would have it like this
under 90 is purple
90.5 to 119.5 is green
120 to 134.5 is yellow/amber
135+ is red
Jan 26 2024 01:52 PM - edited Jan 26 2024 01:57 PM
SolutionYes, 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:
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.
Jan 26 2024 05:15 PM
Jan 26 2024 01:52 PM - edited Jan 26 2024 01:57 PM
SolutionYes, 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:
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.