Use CF to Compare 3 absolut Number Nearest 0

[muhammad susanto]

hi all...

how to make formula in conditional formatting to determine smallest number nearest 0 (absolut number)
find smallest number then use yellow color in same line

this sample :

Excel 2007
	C	D	E
3	data1	data2	data3
4	2	-4	6
5	1	-1	10
6	6	5	3
Sheet1

any help, much appreciated..

m.susanto

 

[Marcelo Branco]

Select C4:E6 being C4 the active cell (the one not shaded)

In Conditional Formatting try this formula
=ABS(C4)=MIN(ABS($C4:$E4))

pick the format you want (fill-->yellow)

Hope this helps

M.

 

[muhammad susanto]

Select C4:E6 being C4 the active cell (the one not shaded)

In Conditional Formatting try this formula
=ABS(C4)=MIN(ABS($C4:$E4))

pick the format you want (fill-->yellow)

Hope this helps

M.

thank you M, worked great!!!