ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I show the low-price supplier from seven different quotes? (https://www.excelbanter.com/excel-worksheet-functions/61676-how-do-i-show-low-price-supplier-seven-different-quotes.html)

!Maniac McGhee!

How do I show the low-price supplier from seven different quotes?
 


JE McGimpsey

How do I show the low-price supplier from seven different quotes?
 
Since you don't give any detail, I'll assume that your quotes are in
B2:H2 and that you want to show the low-price supplier via conditional
formatting.

Select B2:H2, with B2 the active cell. Choose Format/Conditional
Formatting and set the dropdowns and textboxes to

CF1: Formula is =B2=MIN(B2:H2)

Click Format:

Format1: <Patterns/<color of your choice


In article ,
!Maniac McGhee! <!Maniac wrote:


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com