UAMT in Google Sheets #6.11 - Practical Conditional Formatting
*BONUS TUTORIAL*
The Ultimate Athlete Monitoring Toolkit (UAMT) in Google Sheets
Athlete Performance Testing
Module 6: Performance Testing Over Time
#6.11: Practical Conditional Formatting
WHAT WE LEARN
In this tutorial video for The Ultimate Athlete Monitoring Toolkit (UAMT) in Google Sheets, we set rules up to automatically color-code our dynamic athlete performance testing over time grid. We use colors (e.g., use conditional formatting) to immediately identify when an athlete was not a full participant in testing, and identify the athlete’s all-time best and worst performance for each test or metric. We cut through the fluff of conditional formatting that rarely gets us what we want, and go straight into a practical approach to identify the things that matter most to us.
FREE TEMPLATE
If you would prefer to use pre-made athlete profiles rather than creating your own with me from scratch, use the link below to make a copy of the datasets used in the Athlete Performance Testing portion of this project:
https://docs.google.com/spreadsheets/...
CHEAT CODE
The UAMT is a great Google Sheets learning experience, but it also requires a lot of time and effort to complete. If you want to take a shortcut to the gold at the end of the rainbow, I have an opportunity for you. You can purchase the Google Sheets file that is developed from accomplishing all tasks presented in the tutorial videos for The Athlete Performance Testing portion of The Ultimate Athlete Monitoring Toolkit (UAMT), here: https://adamvirgile.com/product/ultim...