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