redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all
I have a small (hopefully getting bigger) database of running stats populating columns A:T
I would like my PB (Personal Best) times for each type of training I do highlighted using a specific code that populates cells through column C
For example I would like my PB highlighted where the code through column C equals WGSC and all the times for this code are held through column E
so in above example WGSC with a time of 21:20 is the best so I would like cells A:T of that row highlighted in light yellow
Hope this makes sense,
Kind regards
I have a small (hopefully getting bigger) database of running stats populating columns A:T
I would like my PB (Personal Best) times for each type of training I do highlighted using a specific code that populates cells through column C
For example I would like my PB highlighted where the code through column C equals WGSC and all the times for this code are held through column E
03 Jun 18 | poor | WGSC | 5k | 23:34 |
05 Jun 18 | OK | WYTT | 5k | 26:15 |
08 Jun 18 | OK | WGSC | 5K | 21:20 |
so in above example WGSC with a time of 21:20 is the best so I would like cells A:T of that row highlighted in light yellow
Hope this makes sense,
Kind regards