When I select a column and apply the conditional formatting to it to find duplicate values, it only changes the text colour and not the cell. According to the settings I have chosen in the image below, the cell and the text should be changing colour.

Excel Screenshot.PNG