Forum Discussion
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...
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
Sergei,
Hopefully this is the last post by me. I was able to adjust the codes arrays to fit my spread sheet and make it work. Sorry for the back and forth, but thank you again for your help. I guess I need to work on it a bit before I ask for help.