muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
how to make in Conditional Formatting highlighted cell e.q. yellow with criteria :
1. Only biggest number choice ; and
2. the number in absolute format (positive or negative number);or
3. the number is zero (0)
for criteria 1 and 2, this formula below worked well but for criteria 3 not work..
=AND(F6<>0,ABS(F6)=MAX(ABS($F6:$H6)))
how to modify it than can working well for 3 criteria above..
thanks in advance..
-sst.
how to make in Conditional Formatting highlighted cell e.q. yellow with criteria :
1. Only biggest number choice ; and
2. the number in absolute format (positive or negative number);or
3. the number is zero (0)
for criteria 1 and 2, this formula below worked well but for criteria 3 not work..
=AND(F6<>0,ABS(F6)=MAX(ABS($F6:$H6)))
how to modify it than can working well for 3 criteria above..
thanks in advance..
-sst.