In the scenario below, the table contains random integer values.
I want to use conditional formatting in order to highlight the values in the table between the specified min and max values.
While I could hard-code 2 and 15, those are subject to change, and I'm primarily looking for a way to adjust the format rules so that they are reading the values in A2
and B2
, not 2 and 15.
Google-sheets – How to conditional format a table in Google Sheets based on two other cell values
conditional formattinggoogle sheets
Related Topic
- Google Sheets Conditional Formatting – Alternate Row Color by Unique Sorted Values
- Google-sheets – Use non-linear color scale for conditional formatting in Google Sheets
- Google Sheets – How to Use IF, AND Conditional Formatting
- Google Sheets – Conditional Formatting with Color Scale for Multiple Rows
- Google-sheets – Conditional Formatting IF/AND Google Sheets
- Google Sheets – How to Define Max and Minimum Series
- Google-sheets – Is it possible to highlight the minimum value in a table on Gsheets
- Google Sheets – Conditional Formatting Based on Data in Two Columns
Best Answer
You can use the following formula under conditional formatting:
(Adjust ranges to your needs)