Personal Best times - highlight range in row

[redspanna]

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

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

 

[Fluff]

You can use CF for that using
=AND($C1="WGSC",$E1=MIN($E:$E))