Mark the Lowest price in a price-matrix

**NBVC** · 04-06-2009, 08:31 AM

Select C2:K54 and invoke Conditional Formatting from the Home tab

Select New Rule

Select Use a Formula to determine which cells to format

Enter formula: =AND(C2<=SMALL($C2:$K2,3),C2<>"")]

Click Format to choose your highlighting preferences.

Click Ok

Click Ok to finish.

**raed_237** · 04-06-2009, 09:31 AM

Originally Posted by NBVC

Select C2:K54 and invoke Conditional Formatting from the Home tab

Select New Rule

Select Use a Formula to determine which cells to format

Enter formula: =AND(C2<=SMALL($C2:$K2,3),C2<>"")]

Click Format to choose your highlighting preferences.

Click Ok

Click Ok to finish.

well many thanks my friend, it works like a charm, though there is still one issue, can i make a range of highlighted colors, for example red for the lowest
price, orange for the second lowest and yellow for the third lowest, thanks again and much appreciated.

**NBVC** · 04-06-2009, 09:34 AM

See attached...

3 separate conditional formats are now applied

=AND(C2=SMALL($C2:$K2,1),C2<>"")

=AND(C2=SMALL($C2:$K2,2),C2<>"")

=AND(C2=SMALL($C2:$K2,3),C2<>"")

**raed_237** · 04-06-2009, 09:42 AM

Originally Posted by NBVC

See attached...

3 separate conditional formats are now applied

=AND(C2=SMALL($C2:$K2,1),C2<>"")

=AND(C2=SMALL($C2:$K2,2),C2<>"")

=AND(C2=SMALL($C2:$K2,3),C2<>"")

Man...What can i say?
really appreciate ur help mate, thanks alot and may God bless u