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'.
