Format the 3 numbers in a column closest to ZERO

[Ultimate Selector]

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>

 

[Ultimate Selector]

Using a negative number seems to mess it up cuz I have tried several different ways and several different format techniques.

 

[Peter_SSs]

Can you help me fix it so it will only HL -10 and below. When I say below I mean -11, -12 etc..

Has the object of CF changed. This seems to be implying that you only want to highlight numbers below -9. Is that the case?

In the earlier posts you were wanting to highlight the numbers closest to 0 or closest to 50 no matter whether the numbers were above or below those values.
Can you clarify?

As with the earlier tasks, some sample data and expected results would help to clarify.

 

[Ultimate Selector]

Yes that is correct ... I am serving another function separate from the other one. I'm still good with that one.
I want to HL all numbers below -9

Thanks Pete!

 

[Ultimate Selector]

Here is a column of sample data.
Column V8 to V14 specifically.

[TABLE="width: 45"]
<tbody>[TR]
[TD]-12%[/TD]
[/TR]
[TR]
[TD]-33%[/TD]
[/TR]
[TR]
[TD]-7%[/TD]
[/TR]
[TR]
[TD]-22%[/TD]
[/TR]
[TR]
[TD]-4%[/TD]
[/TR]
[TR]
[TD]-18%[/TD]
[/TR]
[TR]
[TD]-4%[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

I want to HL all numbers below ...

All numbers or just the closest 3 below?

... below -9

Below -9 or below -9%?

 

[Ultimate Selector]

-9%

All numbers that are -9 and below.
If there is one then just one. But if there are say 3 that are below -9 or lower then all three of those numbers.

 

[Peter_SSs]

Then this is a very different scenario to the previous one and a very simple CF formula should do it for you.

Excel Workbook
	V
8	-12%
9	-33%
10	-7%
11	-22%
12	-4%
13	-18%
14	-4%
CF below -9%

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
V8	1. / Formula is =V8<-0.09	Abc

 

[Ultimate Selector]

Well once again you earned your keep Pete!
I was using a whole number of -9 instead of the -0.09 in my CF formula.

I knew it had to be something simple but I would have never thought it was that.
U Da Man! Many Thanks Pete!

Have a terrific Morning!
-U.S.

 

[Ultimate Selector]

Hi Pete,

Hope all is well ...

I have one more issue for you to resolve if you could please.

I am trying to add up the net value of these individual rows.

Then I want to also add up just the positive numbers by themselves for each row.

Then I want to also add up just the negative numbers by themselves for each row.

The issue is that these are all in % (percentages). I can't seem to tackle this one. I know it's gotta be simple tho.

Here is my sample data for you.

<colgroup><col style="mso-width-source:userset;mso-width-alt:1582; width:34pt" width="45" span="3"> </colgroup><tbody>
[TD="class: xl66, width: 45"]5%
[/TD]
[TD="class: xl64, width: 45"]-11%[/TD]
[TD="class: xl65, width: 45"]-6%
[/TD]

[TD="class: xl66"]3%[/TD]
[TD="class: xl64"]-8%[/TD]
[TD="class: xl65"]-5%[/TD]

[TD="class: xl66"]-27%[/TD]
[TD="class: xl64"]-36%[/TD]
[TD="class: xl65"]-63%[/TD]

[TD="class: xl66"]4%[/TD]
[TD="class: xl64"]-12%[/TD]
[TD="class: xl65"]-8%[/TD]

</tbody>

Thanks Pete!

Regards,
U.S.

 

[Peter_SSs]

Like this? Each formula copied across.

Excel Workbook
	A	B	C	D
1
2		5%	-11%	-6%
3		3%	-8%	-5%
4		-27%	-36%	-63%
5		4%	-12%	-8%
6	Net	-15%	-67%	-82%
7	Positive	12%	0%	0%
8	Negative	-27%	-67%	-82%
% Calculations