D
De
--
De
De
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Raffael
If I understood you right, do a CTRL+F and type what you're looking for (is
it "MAX" ?). Click the Options button, and set it to search in formulas, and
not values.
it "MAX" ?). Click the Options button, and set it to search in formulas, and
not values.
D
De
Thanks, Raffael, but I wondered if there was a conditional format etc that
might do it as I have 200 rows and 58 columns of data. I have entered a
"max" formula for each row and need to know which cell in each row contains
the "max" result.
might do it as I have 200 rows and 58 columns of data. I have entered a
"max" formula for each row and need to know which cell in each row contains
the "max" result.
E
Elkar
You can use conditional formatting for this.
Select your entire range of data
From the Format Menu, choose "Conditional Formatting..."
Set Cell Value "Equal to" and type in: =MAX($A1:$BF1)
Set your format (red background maybe?)
Click OK
Change the above formula to match your actual range of data.
The Maximum value(s) in each row should now be highlighted.
HTH,
Elkar
Select your entire range of data
From the Format Menu, choose "Conditional Formatting..."
Set Cell Value "Equal to" and type in: =MAX($A1:$BF1)
Set your format (red background maybe?)
Click OK
Change the above formula to match your actual range of data.
The Maximum value(s) in each row should now be highlighted.
HTH,
Elkar
R
Raffael
Ok, in that case you're right and may use the "conditional formatting". I
have some personal spreadsheets that use this kind of logic.
So, you should select "Formula is" in the conditional formatting box, type
something as "=MAX($A1:$BZ1)" and select the formatting that you want to
highlight the cell with the max value in that row.
One way you can do that is selecting the entire matrix, making sure that the
line in the formula would be the same as the one in the formula. You must
block the columns, but not the rows.
Regards
have some personal spreadsheets that use this kind of logic.
So, you should select "Formula is" in the conditional formatting box, type
something as "=MAX($A1:$BZ1)" and select the formatting that you want to
highlight the cell with the max value in that row.
One way you can do that is selecting the entire matrix, making sure that the
line in the formula would be the same as the one in the formula. You must
block the columns, but not the rows.
Regards
D
De
Thank you Elkar. I just tried it and it works perfectly. Thanks, again.
D
De
Thank you, Raffael. I found that worked if I "cell is" in the conditional
formatting box. Many thanks,
formatting box. Many thanks,