World Cup Spreadsheet: Group Table & Winning Team

[ekeogh]

Hi All,

I have just designed a world cup spreadsheet that keeps track of match results and then feeds into a group table and this is where my question comes in.

(1)I want to format the table so that it keeps the team with the most points at the top and then sort in descending order automatically without me formatting the group table manually.

(2)I also want the winning team in each match to autmatically change its font color to the following: WIN (BLUE) LOOSE (RED) DRAW (GREEN) how do I this

I cannot find anything on how to do this, is this task possible.Once other thing that should be know is that there are functions in every cell of this group chart and I hope this does not deter me in performing this.

Is there anyway I can attach my sheet here, I dont see any attachment functions?
<!-- / message -->

 

[warren_s]

Hi
What I would do is make a small vba script so when specific cells change, it will run the macro and re-sort the data automatically.

You can use conditional formatting to do the color changing.

These are my thoughts, I hope this helps.

 

[ekeogh]

Hi
What I would do is make a small vba script so when specific cells change, it will run the macro and re-sort the data automatically.

You can use conditional formatting to do the color changing.

These are my thoughts, I hope this helps.

Hi,

I would do that if I knew how...sorry im not that proficent at excel...can you lay it out for me?