Value 1 in the screenshot should be light green. Instead, its white because its not picking up the background color. My condition is if values are between 1 and 1.99, then use green as the background color. 1 and 1.99 particularly are still white. Looks like between doesn’t include the min and max values in the condition.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Highlighting the specific value | 6 | 349 | February 9, 2024 | |
| Conditional Formatting Not Working On % Value | 1 | 243 | August 24, 2023 | |
| How to round Totals and Subtotals of a Pivot table | 3 | 644 | November 14, 2023 | |
| How set background of cell depending on the thresold value in Pivot Table | 2 | 44 | March 25, 2025 | |
| Applying a Gradient Conditional Formatting Based on the Table Data Value Range | 2 | 494 | April 30, 2024 |
