This short video youtu.be/RsEt6gJgZKw shows how to apply conditional formatting based on a calculated value.