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