Essentially I'm trying to create a table for tracking fitness goals. I would like to use conditional formatting to highlight personal bests, according to the type of exercise done. So, for example, if I've done HIIT for 1 hour, and that's the longest time I've done it for, the row containing the data turns blue. If I've been running for distance, and managed to run 5.5km and beaten my previous record, the 5.5km cell turns green.
e.g.
Distance Formula
=AND($E3="Distance",$C3=MAX(IF($E$3:$E$20="Distance",$C$3:$C$20)))
HIIT Formula
=AND($E3="HIIT",$D3=MAX(IF($E$3:$E$20="HIIT",$D$3:$D$20)))