Using wildcard characters to highlight dates
In this task, you will create a formula using wildcard characters to highlight any dates that are in 2018.
この演習はコースの一部です
Google Sheetsで学ぶデータ可視化
演習の手順
- Highlight the
Datevalues inA17:A26and use conditional formatting with a 'Text contains' rule, passing in the value??-??-18. - Set the formatting such that the cell background of any date in 2018 is 'light green 2'.
