In this article I will post some excel formulas that I have used and might need again sometime. From time to time I might edit this post and add additional formulas.

• Find duplicate entries in a range of cells

Select the range of cells you want to check –>Format –>Conditional Formating –>Formula is – add the formula

=IF(COUNTIF($A1:$A$1;$A1)-1>0;TRUE;FALSE)

Press Format and change the formating for these cells

• Find cells that do not have exactly 12 digits

Select the range of cells you want to check –>Format –>Conditional Formating –>Formula is – add the formula =LEN(B1)<>12

Press Format and change the formating for these cells