Multiple conditional formatting MINIFS

[duteberta]

I want to Conditional format ONLY THE ONE CELL that contains the lowest value, but only in there is a "1" in the SEL column. For some reason I'm not able to get the correct syntax for the Conditional Formatting formula.

In this example I'm working within a table named "data". I want the cell in column "WT" to be highlighted if it is the lowest value in that column, but only if there is a "1" in the SEL column.

Can you help me?

example.xlsx
	A	B	C
1	DATE	SEL	WT
2	10/1/24	1	335.0
3	10/2/24	1	334.2
4	10/3/24	1	334.1
5	10/4/24	1	335.1
6	10/5/24	1	333.9
7	10/6/24		333.7
8	10/7/24		334.2
9	10/8/24		332.8
10	10/9/24		333.0
11	10/10/24		332.8
12	10/11/24		333.4
13	10/12/24		333.0
14	10/13/24		332.8
15	10/14/24		332.5
16	10/15/24		332.6
Sheet1

 

[Cubist]

You're welcome. Glad we can assist.