lowest valu or eqaul values in range of cells

[ahsk]

Hi guys :

I have problem sorting lowest value in a range of cells
e.g. Cells A7 B7 C7 and D7 with currency rate
12 13 14 11
What I want is to color automatically th lowest cell
D7 in the above example or same rates in two cells
of same row as below

A7 B7 C7 D7
11 12 13 11
in the later example botth the cells A7 & D7 to be highlighted
by any color.
Kind Regards

[Andrew-R]

Select cells A7:D7 and then apply conditional formatting using the "Top/bottom" rules and set it to format the bottom 1 of the range and pick the colour you want it to be.

[dilipandey]

HI ahsk,

Use the below formula in conditional formatting :-

Please Login or Register  to view this content.

see attached min - highlight.xlsx




Regards,
DILIPandey
<click on below * if this helps>

[ahsk]

Thanks Dilipanday for your reply
Its not so I want it to valid in VBA module cause
the range is multiple say A7:D200
and each row containing four column values varying
as I always enter the new currency values in four columns
and save as that workbook for that particular data.

so whenever I enter values the lowest cells automatically highlighted.

Hope u understand

Thanks again

[oeldere]

There is no VBA in the file.

You have only to change the conditional format formula, you got from DILIPandey.

See the attached file.