[FREE EBOOK]20 Most Powerful Excel Conditional Formatting Techniques!: Save Your Time With MS Excel by Andrei Besedin - QUẢN TRỊ EXCEL Chào mừng các bạn đến với QuanTriExcel.info - Không gì là Không thể... Về thủ thuật Excel, học lập trình VBA, phần mềm chuyên dụng, kế toán, kĩ năng sống ...

# [FREE EBOOK]20 Most Powerful Excel Conditional Formatting Techniques!: Save Your Time With MS Excel by Andrei Besedin

Author:Andrei Besedin
Language: eng
Format: azw3 + pdf
Published: 2019-08-01T07:00:00+00:00
Technique 10
Here we want to format the lowest bid made by these companies.
The function we will use:
MIN
INDEX
MATCH
Explanation:
In the vendor for lowest bid column we used this formula =INDEX(\$A\$2:\$E\$2,MATCH(MIN(\$A3:\$E3),A3:E3,0)) to calculate the company who made the lowest bid.
At first, we will select the column only with numbers in it and then press (ALT + H + L + N).
We will build formula in to the NEW FORMATTING RULE dialog box.
The formula is =MIN(\$A3:\$E3)=A3.
We calculated the minimum number and made it equal with each cell.
If the value of the minimum number is equal to each cell, the cell only with the minimum number will be formatted
#evba #etipfree #eama #kingexcel