How to find duplicate value in Google Sheets

How to highlight cell if value duplicate in same column for google spreadsheet? Step - 01: Select the whole column (your desired column) Figure 01 : Google Sheets Conditional formatting Figure 02 : Google Sheets Conditional formatting Figure 03 : Google Sheets Conditional formatting Figure 04 : Google Sheets Conditional formatting Step - 02: Click on Format menu Figure 05 : Google Sheets Conditional formatting Step - 03: Click Conditional formatting sub-menu Figure 06 : Google Sheets Conditional formatting Step - 04: Click on Format cells if... dropdown button Figure 07 : Google Sheets Conditional formatting Figure 08 : Google Sheets Conditional formatting Figure 09 : Google Sheets Conditional formatting Figure 10 : Google Sheets Conditional formatting Step - 05: Click on Custom formula is Figure 11 : Google Sheets Conditional formatting Figure 12 : Google Sheets Conditional formatting Figure 13 : Google Sheets Conditi...