highlighting highest value cells

[ratheesh]

i want to know about how to highlight the highest value cell in a rows of
data which we enter the marks or the prices in another same range row, what
is the formula for using this function? i f anybody can know plz help

 

[Gary''s Student]

Use Conditonal Formatting:

Let's say we want to hilight the highest value in row #7. Click on A7 and:
Format > Conditional Formatting... > FormulaIs > =A7=MAX(7:7) and then
pick a highlight colour.

Then copy A7 and paste/special/format across the row.

For more information see:

http://www.contextures.com/xlCondFormat01.html