Highlighting duplicates
For this task, have a go at creating a formula that will highlight the duplicates in the
Low data.이 연습은 강의의 일부입니다
Google Sheets로 배우는 데이터 시각화
연습 안내
- Highlight the
Lowdata inE17:E26and create a conditional format rule using the 'Custom formula is', entering the formula=countif($E:$E,E17)>1. - Change the formatting such that any duplicated cells are highlighted by changing the 'Fill color' to 'light red 2'.
