Sir,

I have enclosed a model spread sheet which has certain values across the rows and columns.

I want to identify/locate the highest/lowest values across the rows and columns of the spread sheet.

In the model table I have marked the highest values across the rows of the spread sheet as one of the solution.

Can anyone help me with a formula towards the above requirement.

Thanks in Advance!!

varadhu

This appears to be your third question about spreadsheets.

I am suggesting that all of your questions be combined.

Hi varadhu

Conditional Formatting Rules.

For the MAX on each row:
=B2=MAX($B2:$G2)

For the MIN on each row:
=B2=MIN($B2:$G2)

Format as required

Kevin

This appears to be your third question about spreadsheets.

I am suggesting that all of your questions be combined.

Thanks for your valuable suggestion!

But the problem is: I don't have all the questions(problems) listed before me to be asked one by one.

Whenever I face a problem in my study/working area, I try to solve it on my own. If it is not possible, I humbly throw the same before our "ask me help" elite members for a solution. And I get it solved most of the times. That is all.

varadhu

Hi varadhu

Conditional Formatting Rules.

For the MAX on each row:
=B2=MAX($B2:$G2)

For the MIN on each row:
=B2=MIN($B2:$G2)

Format as required

Kevin

Dear Kevin,


I don't understand in which column or box, I shall apply your formula and get the desired result.

First thing, I don't want the result to be exhibited in a separate column as max or min figures like 117.9, 8.05, 70 etc.

All I want is to locate the maximum or minmum values within the table and that too in its original place itself.

In the model table there are limited inputs from A1 to G11. The solution must identify the maximum and minimum values within the table and highlight its location visibly for identification.

Hope I conveyed my need in full.

Thanks again
varadhu

Hi Hi varadhu

Conditional formatting, select cells B2:G11

Then apply the rules. For Excel 2007 +. On the Home Tab > Conditional formatting > new rule. Or keyboard shortcut: ALT + H L N

Hi Hi varadhu

Conditional formatting, select cells B2:G11

Then apply the rules. For Excel 2007 +. On the Home Tab > Conditional formatting > new rule. Or keyboard shortcut: ALT + H L N

Thank you Kevin,
I had a very long break visiting the site because of personal reasons.
Hence could not read your timely reply which was optly drafted to make me understand easily the solution.
Sorry for the delay in posting this response
Thank You once again!
It had worked.
Varadhu