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>
</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.
1.4 |
0.9 |
0.1 |
-6.7 |
-9.3 |
-7.6 |
-4.7 |
-0.8 |
-1.6 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:1512;width:33pt" width="43"> </colgroup><tbody>
</tbody>