Forum Discussion
Swim Times - mm:ss.00 format but numerical so you can do formulas and conditional formatting
Hi there - I have spent a lot of time trying to get the formulas to work for this. I am doing simple formulas for swim times. Cell A1 would be a swimmers actual swim time - let's say 50mFree - ...
A slightly shorter formula:
=IF(A2 < A1, "-", "")&TEXT(ABS(A1 - A2), "mm:ss.00")
Select the cell(s) with the formula and set the fill color to green (this will be the default.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Select 'Specific Text ' from the first drop down.
Select 'containing' from the second drop down.
In the box next to it, enter the formula
="-"
Click Format...
Activate the Fill tab.
Select red as fill color.
Click OK, then click OK again.