Conditionally highlight cells or ...

[linyinow]

Hi, Could anyone help me with this problem? Here is th
table:

Apple Banana Orange Pear
15 45 20 335
85 65 44 77
11 787 88 936


I want to either to be able to 1)use a function to return the name o
the fruit containing the lowest level in each raw, so for first row i
would return "Apple", sedond row would return "Orange", etc. Can an
of you help me writing this function? 2) or if possible, i'd like t
highlight the cell in each row that contains the lowest value, so fo
first row, cell containing 15 will be highlighted. Can anybody help m
with that? Thanks very much

 

[Dave Peterson]

With your data in A2xxx (headers in A11), put this E2:

=INDEX($A$1:$D$1,MATCH(MIN(A22),A22,0))
and drag down.

Select your range A2xxx and with A2 the activecell:
Format|conditional formatting
Formula is:
=A2=MIN($A2:$D2)

And use a nice pattern.

 

[Mladen_Dj]

Apple Banana Orange Pear
15 45 20 335
85 65 44 77
11 787 88 936


I want to either to be able to 1)use a function to return the name of
the fruit containing the lowest level in each raw, so for first row it
would return "Apple", sedond row would return "Orange", etc. Can any
of you help me writing this function? 2) or if possible, i'd like to
highlight the cell in each row that contains the lowest value, so for
first row, cell containing 15 will be highlighted. Can anybody help me
with that? Thanks very much!

If you put your table in range A14, than, for returning a name of the
fruit with lowest level in each row use formula:

=INDEX($A$1:$D$4,1,MATCH(MIN(A22),A22,0)),

where $A$1:$D$4 is the range of table with fruit, 1 is row number from which
index function returns reference, and MATCH returns column which have min.
value in this row.

To higlight minimal value in each row, select rows 2:4, and go to
Format->Conditional Formating, and in dialog select "Cell value is equal to"
and in reference field put formula:

=MIN($A2:$D2),

and choose desired font, border or pattern.