Formula To Determine Last Entry

[VinceF]

Greetings,
Hopefully I can explain this clear enough.
I have a worksheet with column A1:A40 where players names are inserted.
Column E1:E40 I enter a number representing the corresponding players score.

In this instance there are only 10 players which would place that players name in cell H10.
Once the last players score from column H (H10 in this example) is entered in the corresponding cell (E10) the condition (formula) would be met and is considered the last entry.
Once the condition is met, via CF I would have it highlight cell C1.
Hopefully this can be done with helper cells.

Very much appreciate your assistance.
VinceF
Win10
Office365

 

[rowebca]

Can you show this in a screenshot or a file? It is very confusing how you explained it. One example:

In this instance there are only 10 players which would place that players name in cell H10.

All the name are placed in one cell or in cell H1 to H10?

Try to explain in a way we can understand and give you a solution.

Regards,
GB

 

[VinceF]

GB,
Thank you for the reply...I will try to take a screenshot and post here.
In the meantime to answer your question...
In this example there are 10 players, Player #1 is in cell H1, Player# 2 is in cell H2, and so on.
Player#1's score would be place in cell E10, Player#2's score is placed in cell E11 and so on.

 

[VinceF]

In my previous attempt to explain this I simply used random Columns..
This is the actual spreadsheet and the players names are in column H11:H51 and the last score entry is in column AI11:AI51
The cell I want to highlight via CF is cell T2

Hope this helps

 

[rowebca]

What "CF" means?
And AI column I see it "Individual Bets", still all this is unclear for me.

Please make me understand how you determine the last score entry.

Regards,
GB

 

[VinceF]

What "CF" means?

Conditional Formatting
When the condition is met I will have the cell filled yellow via CF (Conditional Formatting )

 

[Peter_SSs]

Like this?

25 02 09.xlsm
	H												T															AI
1
2
3
4
5
6
7
8
9
10
11	Name 1																											6
12	Name 2																											5
13	Name 3																											3
14	Name 4																											4
15	Name 5																											5
16	Name 6																											3
17	Name 7																											8
18	Name 8																											5
19	Name 9																											4
20	Name 10
21
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
T2	Expression	=COUNTA(H11:H51)=COUNTA(AI11:AI51)	text	NO

When the last score is entered.

25 02 09.xlsm
	H												T															AI
1
2
3
4
5
6
7
8
9
10
11	Name 1																											6
12	Name 2																											5
13	Name 3																											3
14	Name 4																											4
15	Name 5																											5
16	Name 6																											3
17	Name 7																											8
18	Name 8																											5
19	Name 9																											4
20	Name 10																											5
21
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
T2	Expression	=COUNTA(H11:H51)=COUNTA(AI11:AI51)	text	NO

 

[VinceF]

Peter,
Thank you for the solution, I was able to make it work exactly as needed.
Very much appreciated.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.