How do I auto highlight a cell with the same data as another c
I applied your formula but it didn't work. Have you tried yourself?
"Stefi" wrote:
If numbers are in column A then apply conditional formatting to column A with
this formula:
=COUNTIF(A:A,A1)1
and assign a pattern to it!
Regards,
Stefi
€˛john talbot€¯ ezt Ć*rta:
I have a spreadsheet containing lists of serial numbers. If I enter a serial
number which already exists in the spreadsheet, I would like the new cell to
be highlighted to indicate that the entry already exists - is this possible?
|