Conditional formula to format "Personal Best"
Posted on 2011-10-30
I'm not sure if this is possible, but I'd like to conditionally format a row based on the premise that the value is greater than any previous value.
This if for recording my kids Little Athletics results. If they beat they previous time it's a PB. At the moment I can only work out conditional formatting if it's their best time, so in effect if they beat their PB every week there will only be one highlighted cell, not a highlight every time it was a PB.
Just to clarify, in the example below for 100m times:
19.2, 18.8, 19.3, 18.7, 18.0, 18.1
The second, forth and fifth values should be highlighted. It may be necessary that the first one also is as technically it's a PB. Ideally the formula would recognise this didn't beat any other time so wouldn't highlight it. I don't mind if this is highlighted though.