VinceF
Board Regular
- Joined
- Sep 22, 2007
- Messages
- 220
- Office Version
- 2016
- Platform
- Windows
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
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