Ultimate Selector
Board Regular
- Joined
- Dec 15, 2013
- Messages
- 153
Ok so here is what I'm trying to do. Here are my numbers ..
I want to highlight the three lowse numbers closest to zero. Which would be numbers
0.1 , -.08 and 0.9 ...
I have tried several formulas but nothing has worked.
Any suggestions or the right conditional format formula would be greatly Appreciated!
Thanks in Advance!
U.S.
<colgroup><col style="mso-width-source:userset;mso-width-alt:1512;width:33pt" width="43"> </colgroup><tbody>
[TD="class: xl64, width: 43"]1.4[/TD]
[TD="class: xl65"]0.9
[/TD]
[TD="class: xl65"] 0.1
[/TD]
[TD="class: xl65"]-6.7[/TD]
[TD="class: xl65"]-9.3[/TD]
[TD="class: xl65"]-7.6[/TD]
[TD="class: xl65"]-4.7[/TD]
[TD="class: xl65"]-0.8[/TD]
[TD="class: xl65"]-1.6
[/TD]
</tbody>
I want to highlight the three lowse numbers closest to zero. Which would be numbers
0.1 , -.08 and 0.9 ...
I have tried several formulas but nothing has worked.
Any suggestions or the right conditional format formula would be greatly Appreciated!
Thanks in Advance!
U.S.
<colgroup><col style="mso-width-source:userset;mso-width-alt:1512;width:33pt" width="43"> </colgroup><tbody>
[TD="class: xl64, width: 43"]1.4[/TD]
[TD="class: xl65"]0.9
[/TD]
[TD="class: xl65"] 0.1
[/TD]
[TD="class: xl65"]-6.7[/TD]
[TD="class: xl65"]-9.3[/TD]
[TD="class: xl65"]-7.6[/TD]
[TD="class: xl65"]-4.7[/TD]
[TD="class: xl65"]-0.8[/TD]
[TD="class: xl65"]-1.6
[/TD]
</tbody>