Forum Discussion
Benjamin Abair
Apr 20, 2018Copper Contributor
Conditional Formatting
Okay I need some help. I've watched just about every video and read every article I can find and nothing is working or answering my question directly and frankly I'm not good enough with excel to fig...
SergeiBaklan
Apr 20, 2018Diamond Contributor
Hi Benjamin,
Assuming your figures are in every odd column you may find, for example, third smallest as
=AGGREGATE(15,6,1/ISODD(COLUMN($C$14:$M$14))*$C$14:$M$14,3)
to highlight third smallest in your range you may apply conditional formatting rule
=C14=AGGREGATE(15,6,1/ISODD(COLUMN($C14:$M14))*$C14:$M14,3))*ISODD(COLUMN(C14))
and similar rules for first and second smallest. Result will be as
and in attached
Benjamin Abair
Apr 21, 2018Copper Contributor
Sergei,
For some reason when I copy your formula from the text it doesn't work. So I downloaded the file you attached and it works just fine. Not sure what's going on there buy you are a serious time saver. Thank you so much for your help.