Conditional

[Zsolt Szabó]

Hi, good morning everybody

I need your help! I have a list and I like to use it like this. Colum A =
Product Name A2:A18 ; Row 1 = Size B1:U1 ; The prices of these products are
in cells B2:U18 . When my costumer is asking me a list – for example $40.00
or cheaper products list - I like to give them a list and make sure there is
no duplication in it. I tried the VLOOKUP IF formula but I couldn’t make it
right.

 

[Ag]

One way to highlight the resultset is using a conditional formatting
where you put in a greater than cell value rule assuming the data is
as per structure below

Name Small medium large
p1 3 4 34
p2 34 43 65
p3 34 101 101
p4 234 45 43
p5 44 345 455



criteria value
40



Regards
Anirudh