Correcting your report
The conditional formatting rule that you applied in the last exercise is left on to start with in order to show two ways that dates can be bad.
A date won't be recognized if you add a suffix to the day, such as 26th instead of just 26. Additionally, February 30, 2024 will never exist, so that's also bad.
Let's start by cleaning up the data.
この演習はコースの一部です
Google スプレッドシートの条件付き書式
演習の手順
- Correct the incorrect dates by removing the "th" from February 26th and delete the entire row with February 30, as there are 0 hours anyway.
- Once the dates are fixed, delete that conditional formatting rule.
