In the cells below (AN25:BL25) I want to use conditional formatting to highlight the cell whose value is nearest to cell AM25 (Zero)
I have tried the formula =ABS(AN25-$AM$25)=MIN(ABS($AN$25:$BL$25-$AM$25)) which doesn't seem to work.
Also note that between each of the cells there are two hidden columns which do NOT contain any data or formulas.
Any help would be greatly appreciated.
I have tried the formula =ABS(AN25-$AM$25)=MIN(ABS($AN$25:$BL$25-$AM$25)) which doesn't seem to work.
Also note that between each of the cells there are two hidden columns which do NOT contain any data or formulas.
Any help would be greatly appreciated.