Auto highlighting selected cells

[Dave Jobes]

Hello.
My request is relatively straight forward in excel terms but I am trying to work out how to automatically highlight a cell in a score sheet.
For example there are a list of 10 players and each players scores are accumulated. As these scores get higher or in the case of a golf score sheet, lower I am trying to identify the leading score. I can do this manually but I have seen advanced spreadsheets where this is done automatically and I was wondering if someone could explain or advise how to do this please

Thanks in advance

Dave J

 

[footoo]

One way is with Conditional Formatting : https://www.techonthenet.com/excel/questions/cond_format3_2010.php

 

[Dave Jobes]

Thanks I will have a look at this

 

[Dave Jobes]

Exactly what was looking for, thanks a lot

 

[Dave Jobes]

Auto sorting rows in excel

hello again, I am wondering if it is possible to auto sort rows in a score sheet. I have a golf score sheet which comprises 13 rows. Each row contains 22 cells and the total for each player is calculated in the 23rd cell. Its difficult to explain, ideally I would like to post a snap shot of the table here but I cant work out how to do it.

As each players score gets lower (golf) then that player needs to auto move to the top of the table. Is this possible in excel 2007 please?

Is there a way I can attach a snap shot of table to a thread on here ?

thanks

 

[Fluff]

Re: Auto sorting rows in excel

@Dave Jobes
As this is a completely different question, you will need to start a new thread.
Thanks