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