List checking

[Akshay Bakhai]

Try this (I am describing it only for one section but you
can use same logic for several sections):

Select all the cells in section 1 and name it "SECTION1"
(you may choose whatever name you like).

Thereafter go to the first cell in the list in section1
and click on menu open FORMAT : CONDITIONAL FORMATTING ...

In the dialog box, for condition 1 select "Formula is".
In the cell for the formula type in the following
=countif(SECTION1, A2) > 1 and thereafter by clicking on
FORMAT button select whatever special formatting that you
want. NB: In this example I have assumed that the address
of the first cell in your list is A2. If it is something
else in your case then please use the appropriate address
of the first cell in your list.

Click on OK.

Now select all cells in your first section, including the
first cell in the list.

From menu select FORMAT : CONDITIONAL FORMATTING ... and
click on OK to apply same formatting to all cells in the
section.

This should do the trick.

Note however that depending on the number of entries you
have and the number of duplicates, the highlighted list
may not be very readable if there are too many duplicate
entries.