Is it possible to apply conditional formatting to one column such that when the cell has the same value (either text or number) as other cell in the column, the current cell will be formatted.
For example:
A1 = XXX
A2 = XXY
A3 = XX1
A4 = XXX
A5 = XXX
Cells A1, A4 and A5 will be formatted to the same color