For example, I have this data 1.5, 1.2, -0.98, 1.01, and I want the cell with the value closest to zero to be highlighted. I tried to create the corresponding rule (see picture) but EXCEL does not color any cell. In my example, the cell with -0.98, since this is the value closest to zero, should be colored.

My first attempt

`=ABS(P74)=1/MAX(ABS(IFERROR(1/$P$74:$P$79;0)))`

?