Small or Large Function in Non Array range in "Conditional Formatting

[Bella Jeon0815]

Dear Guru & Experts,

I have a problem with Conditional Formatting, using Small or Large function.

I'd like to compare and high light only certain cell / column to compare.
For instance, I'd like to only see the smallest and 2nd smallest price from my list using different color. but the range is not next each other.


Current conditional Formatting Formular is like below,
=C7=SMALL(IF($C7:$AG7>0,$C7:$AG7),1)
=C7=SMALL(IF($C7:$AG7>0,$C7:$AG7),2)
=C7=SMALL(IF($C7:$AG7>0,$C7:$AG7),3) .....


But I only want to compare the price columns in the sheet not q'ty or total spend.


How can I formulate right conditional formatting formular ?
Please Advise me !!!






=C7=SMALL(IF($C7:$AG7>0,$C7:$AG7),6)

 

[Somendra Misra]

Hi Bella,

I had a question, do you want to compare prices for all products in each columns, say highlight min and 2nd small in column C and like wise in all other price columns OR

You want to compare prices in rows for each product say on row 7 highlight prices and same for others rows?

OR

irrespective of any product just highlight the prices?

Can you confirm?

Regards,

 

[Bella Jeon0815]

Hi Somendra,

Thanks for asking.

Yes Indeed, I'd like to compare the price in Rows like you mentioned.
for instance, I'd like to compare the price C7, F7, I7, L7,O7,R7,U7 X7,AA7,AD7, AG7 using different color.

Hope it is clear for you and expect good solution !

Thanks in advance for your help !!!

 

[Somendra Misra]

Hi Somendra,

Thanks for asking.

Yes Indeed, I'd like to compare the price in Rows like you mentioned.
for instance, I'd like to compare the price C7, F7, I7, L7,O7,R7,U7 X7,AA7,AD7, AG7 using different color.

Hope it is clear for you and expect good solution !

Thanks in advance for your help !!!

See this file.

Regards,

 

[Bella Jeon0815]

Hi Somendra,

Thanks for your reply. It's amazing. Looks quite complicated. But it works.
I need to study complex formula you've given.

Thanks a lot !!!