Conditional formatting

[Glyn_Levis]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I am writing a spreadsheet to record my archery scores. I would like to highlight cells which contain say the highest score or most golds scored for a particular round. Is there any body who could help?
Many thanks,
Glyn Levis

 

[Bob Greenblatt]

Sure, set the conditional format to a formula that looks like
=max(columncontaingscores). Then format it however yu'd like to highlight
the maximum value.

 

[Glyn_Levis]

Hi Bob,
Thank you for your reply and I have tried to apply your suggestion, unfortunately without success, I'm sure it's me! In the Conditional Formatting box should I be in the 'Formula is' menu or the 'Cell Value is' box? If the row I wish to format is a row and not a column, should I change the wording to =max(rowcontainingscores). Many thanks for your help.
Glyn UK

 

[Glyn_Levis]

Thanks for trying guys but I'm afraid it means absolutely nothing to me!

 

[CyberTaz]

Not the most elegant option, perhaps, but it will work

Let's say your scores are in cells B10 to B50

In some out-of-the-way cell (such as X100, for example) type in:

=MAX(B10:B50)

Then select the cells containing the scores, go to Format> Conditional
Formatting. Leave the option set to Cell Value Is, set the comparison
operator to Equal To, then type X100 in the last box. Click the Format
button & choose your formatting features.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Not the most elegant option, perhaps, but it will work

Let's say your scores are in cells B10 to B50

In some out-of-the-way cell (such as X100, for example) type in:

=MAX(B10:B50)

Then select the cells containing the scores, go to Format> Conditional
Formatting. Leave the option set to Cell Value Is, set the comparison
operator to Equal To, then type X100 in the last box. Click the Format
button & choose your formatting features.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Or, you can just enter the formula =max($b$10:$b$50) in the conditional
format for all the cells.

 

[Glyn_Levis]

Many thanks, a combination of both gave me a solution to the problem. I used: The Cell Value is, equal to, and in the third box I typed, "=MAX($B$10:$B$50)" applied the conditions and it worked.