Conditional Formatting a column based on specific condition on other column?

Question

Given:I have table shown below

| A | Total | % A |
|---|-------|-----|
| 2 | 5     | 40% |
| 4 | 19    | 22% |
| 3 | 10    | 30% |
| 1 | 8     | 13% |
| 1 | 3     | 34% |

And I want to conditional format column % A:

Highest Percentage as Green and Lowest Percentage as Red

But condition is column Total must be greater than or equal to 4 (i.e. >=4) to be considered as particular row to be used for conditional formatting.

For an Example:

In above table I want to perform conditional formatting for only those row in % A whose Total column is (i.e. >=4)

Considering table something like this

| A | Total | % A |
|---|-------|-----|
| 2 | 5     | 40% |
| 4 | 19    | 22% |
| 3 | 10    | 30% |
| 1 | 8     | 13% |

And Now I want to do conditional formatting.

I tried filtering but this formatting those cell also whose Table column is less than < 4.

Thank you for your time and consideration

Answer 1

---

How it works:

• Formula for Highest Value:

---

• Formula for Lowest Value:

---

• Adjust cell references in the formula as needed.