find n highlight max value

I have

A
1 2.22
2 2.23
3 2.33
4 1.44
5 3.44

at A6 i putting the formula to find out the max value at A
=MAX(A1:A5)
which is = 3.44

My question is
how to make the system highlited the max value for me
I mean, highlight the cell A5 after find out it is the max value.
So that i know where is the max value located.
Because i have thousands of numbers...which make me headache to find it out

where to insert the code?
sorry..

No worries,

With your workbook open, press ALT & F11 to open the VB editor

Go to Insert > Module

paste the code into the window that appears.

Close the VB editor.

In your workbook, highlight the range in which you want the highlight to appear, then go to Tools>Macro>Run Macro, and select highlightmax

Dave

thanks...it works preety

alternatively, you could use conditional formatting. Format->Conditional formatting._> formula is =A1=$A$6->Set format.

If I have following two columns

Class-----Rollno
--7-------15
--7-------16
--7-------18
--9-------22
--9-------25
--9-------28
--10------1

Now I want to highlight every row that has max rollno in every class e.g
--7-------18
--9-------28
--10------1

How to highlight above rows with macro