Forum Discussion
Solved
How to apply conditional formatting based on the Minimum column?
The Sold column in the Result is calculated measure. How can I apply the conditional formatting to turn the cell red when the Sold column is less than the Minimum colum (fixed value) value as shown in the Result below?
There are 2 tables: Table1
| FileName | Items | Date | TotalNum | TotalSpoiled |
| ap20250228-01 | Apple | 3/4/2025 | 200 | 10 |
| ap20250228-02 | Apple | 3/4/2025 | 150 | 30 |
| p20250228-01 | Pear | 3/4/2025 | 45 | 3 |
| p20250228-02 | Pear | 3/4/2025 | 100 | 10 |
| p20250228-03 | Pear | 3/4/2025 | 100 | 10 |
| Or20250228-01 | Orange | 3/4/2025 | 150 | 20 |
| Or20250228-02 | Orange | 3/4/2025 | 100 | 10 |
| Or20250228-03 | Orange | 3/4/2025 | 80 | 0 |
| Or20250228-04 | Orange | 3/4/2025 | 65 | 0 |
| Or20250228-05 | Orange | 3/4/2025 | 80 | 4 |
| Or20250228-06 | Orange | 3/4/2025 | 90 | 5 |
| Or20250228-07 | Orange | 3/4/2025 | 55 | 0 |
| On20250228-01 | Onion | 3/4/2025 | 200 | 10 |
| On20250228-02 | Onion | 3/4/2025 | 100 | 5 |
| On20250228-03 | Onion | 3/4/2025 | 180 | 20 |
Table2:
| Source | Target | Minimum |
| Apple | 2 | 3 |
| Orange | 7 | 4 |
| Pear | 3 | 2 |
| Onion | 3 | 1 |
| Pepper | 1 | 1 |
Result:
| Source | Sold | Target | Minimum |
| Apple | 2 | 4 | 3 |
| Orange | 7 | 5 | 4 |
| Pear | 3 | 3 | 2 |
| Onion | 3 | 2 | 1 |
| Pepper | 0 | 1 | 1 |
Thank you!
