Conditional Formatting for Softball Statistics

G

Guest

We are keeping our season's softball statisitcs on the head coach's computer.
We want to higlight a group of stats (i.e. batting average) and have the
highest one with the cell filled in. I've expereimented with several
formulas I've seen here. IT either does not work or we get several cells
highlighted even though they are of different values. Any help would be
appreciated. Thank You.
 
T

T. Valko

Suppose the averages are in the range A1:A5 -

A1 = .455
A2 = .427
A3 = .510
A4 = .400
A5 = .301

Select the range A1:A5
Goto the menu Format>Conditional Formatting
Formula Is: =AND(A1<>"",A1=MAX(A$1:A$5))
Click the Format button
Select the style(s) desired
OK out

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formula formatting 2
Formulas for Conditional Formatting 1
Tough one - Conditional Formatting 1
Conditional formatting formula 11
Conditional formatting in a cell formula 1
Effect of Conditional Formatting, Data Validation 1
Formulas for conditional formatting 3
Use of CELL("protect") in conditional formatting in Excel 07 3

Top