Formatting for a number Double Lower than all others!

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
153
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!


______
5369
8654
8032
3610
7280
3084
3267
1340
3967

<colgroup><col style="mso-width-source:userset;mso-width-alt:1954;width:42pt" width="56"> </colgroup><tbody>
</tbody>




Regards,
U.S.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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!
 
Upvote 0
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
 
Upvote 0
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)
 
Last edited:
Upvote 0
When you created the Cf did you select U16:U24?
 
Upvote 0
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.
 
Last edited:
Upvote 0
You've missed the last argument from the final Small function it should be SMALL($U$16:$U$24,2)/2
 
Upvote 0
Glad to help & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top