20 Most Powerful Excel Conditional Formatting Techniques!: Save Your Time With MS Excel by Andrei Besedin

Author:Andrei Besedin
Language: eng
Format: azw3
Published: 2017-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.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.