Formatting for a number Double Lower than all others!

[Ultimate Selector]

Just a quick qyestion which I'm sure there is a easy answer to but I don't have anyway.


I want to conditionally format a number in a row of numbers (See Example) that is at least Double Lower or more than the rest of the numbers. So in my example the number 1340 would be highlighted in yellow out of the rest of these numbers.


What is the formula or how do I do this so I can have it highlight that number?
Thanks in advance for your help!

<colgroup><col style="mso-width-source:userset;mso-width-alt:1954;width:42pt" width="56"> </colgroup><tbody>
[TD="class: xl64, width: 56"]______
[/TD]

[TD="class: xl65"]5369[/TD]

[TD="class: xl66"]8654[/TD]

[TD="class: xl66"]8032[/TD]

[TD="class: xl66"]3610[/TD]

[TD="class: xl66"]7280[/TD]

[TD="class: xl66"]3084[/TD]

[TD="class: xl66"]3267[/TD]

[TD="class: xl66"]1340[/TD]

[TD="class: xl66"]3967[/TD]

</tbody>

Regards,
U.S.

 

[Ultimate Selector]

I have been trying to research this on google and whatnot. I can't find anything specific on this formatting formula.

It can't be that difficult but I'm sure someone here may know what I should do with this problem.

Again, THanks in advance!

 

[Fluff]

How about
=AND(A3=SMALL(A$3:A$11,1),SMALL(A$3:A$11,1)< SMALL(A$3:A$11,2)/2)
Change ranges to suit

 

[Ultimate Selector]

How about
=AND(A3=SMALL(A$3:A$11,1),SMALL(A$3:A$11,1)< SMALL(A$3:A$11,2)/2)
Change ranges to suit

Thanks, but that didn't seem to work. Here is what I typed in place of your formula, using my range Is this correct?

=AND(u16=SMALL($U$16:$U$24,1),SMALL($U$16:$U$24,1)< SMALL($U$16:$U$24)/2)

 

[Fluff]

When you created the Cf did you select U16:U24?

 

[Ultimate Selector]

Message comes up and says I have entered too few arguments for this function.

 

[Ultimate Selector]

When you created the Cf did you select U16:U24?

Yes, I went into Cf and went to ...

Use a formula to determine and typed in.... =AND(u16=SMALL($U$16:$U$24,1),SMALL($U$16:$U$24,1)< SMALL($U$16:$U$24)/2)


I had the range selected as well.

 

[Fluff]

You've missed the last argument from the final Small function it should be SMALL($U$16:$U$24,2)/2

 

[Ultimate Selector]

You've missed the last argument from the final Small function it should be SMALL($U$16:$U$24,2)/2

Yup that worked! My Bad, I should have proofed my statement!

Much Appreciated!

Regards,
U.S.

 

[Fluff]

Glad to help & thanks for the feedback