How can I find cell contains the result of "maximum" formula
Thank you Elkar. I just tried it and it works perfectly. Thanks, again.
--
De
"Elkar" wrote:
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
"De" wrote:
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.
--
De
"De" wrote:
--
De
|