CF Formula Highligted Cell Only Biggest Number in Absolute Format

[Jhon Mustofa]

hi all..

how to make in Conditional Formatting highlighted cell e.q. yellow with criteria :
1. Only biggest number choice
2. the number in absolute format (positive or negative number)

please, check attachment file.

thanks in advance..

john m

[samba_ravi]

Select F6:H10 and use below formula in conditional format

=AND(F6<>0,ABS(F6)=MAX(ABS($F6:$H6)))

[Jhon Mustofa]

hi man....worked like sunrise ..

thank you

[wladoD]

Hi,

would this be easier...?

=ABS(C13)=MAX(ABS($C13:$E13))

[Jhon Mustofa]

update , sorry
i want new add 1 criteria so became :
1. only biggest number; and
2. in Absolute number; OR
3. the number is zero (0)

[AliGW]

The thread is currently marked as solved ...