Home > Back-end >  (Excel) Conditional Formatting, Change Colour for Highest Value in Column A, if Column B = "x&q
(Excel) Conditional Formatting, Change Colour for Highest Value in Column A, if Column B = "x&q

Time:05-08

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.

Screenshot illustrating proposed CF formulae

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