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


[table="width: 200, class: grid"]
[tr]
[td]03 Jun 18[/td]
[td]poor[/td]
[td]WGSC[/td]
[td]5k[/td]
[td]23:34[/td]
[/tr]
[tr]
[td]05 Jun 18[/td]
[td]OK[/td]
[td]WYTT[/td]
[td]5k[/td]
[td]26:15[/td]
[/tr]
[tr]
[td]08 Jun 18[/td]
[td]OK[/td]
[td]WGSC[/td]
[td]5K[/td]
[td]21:20[/td]
[/tr]
[/table]


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))