How do I auto highlight a cell with the same data as another c
Could you please explain what is the functionality of COUNTIF(A:A,A1)1? I
know it gives true if the numbers are repeated and give false if they are not
equal, but I can't figure out how does it work.
"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?
|