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