How to apply conditional formatting based on the Minimum column?

[Emm]

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!

[Emm]

It works.  Thank you for your help!

[Deku · Accepted solution]

SoldLessMin = If( [Sold] < [minimum], "Red" )

Follow this guide to apply. You can replace the red string with a hex code for a particular shade of red