Conditionally formatting duplicates
We are now going to apply the same logic used in the previous two exercises.
However, we are now going to do it with conditional formatting.
This will create a more readable report where the duplicates are easy to see.
Specify fixed ranges for the formulas in this exercise.
Identifying a fixed range with $'s (A$3:A$18 in this exercise's case) usually produces the same results as referring to an entire column (A:A), but fixing a range is more precise while using the entire column is more flexible.
To ćwiczenie jest częścią kursu
Formatowanie warunkowe w Arkuszach Google
Instrukcje do ćwiczenia
- Conditionally format the cells in the
Namecolumn using a custom formula that applies the Default green background if theCOUNTIFformula is greater than one.- For the first criteria of this first
COUNTIFfunction, fix the rows of the range with$but do not fix the columns (e.g.A$3:A$18).
- For the first criteria of this first
- Write a similar rule that conditionally formats the cells in the
Phone numbercolumn with the same Default green background.
Interaktywne ćwiczenie praktyczne
Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń
Rozpocznij ćwiczenie