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