Conditional highlight in numbers

Hi Pt,

Conditional highlighting rules in Numbers compare the value in the cell to be highlighted to a fixed value, written into the rule or to the value in another specified cell.

You could set up an auxiliary column to count the occurrences of the name or number in the space where one might occur (usually that would mean 'in the same column as the name/number being tested, and to copy that name/number into the cell containing the formula if the count was greater than 1.

The CH rule, assigned to the original cell, would apply the highlight when the text in the counting cell matched that in the original cell.

The auxiliary column would be needed only by the CH rule, and could be hidden.

The formula shown below the table is entered in D2, filled right into E2, then filled down the rest of both columns.

Select all of column A except the header row) and apply the CH rule shown:

The same rule may be applied to column B, using D2 as the comparison cell (and must be, if the 'numbers' in column B are actually text due to inclusion of non-numeric characters). If they are all recognized as numbers by Numbers, you could use the rule below:

Regards,

Barry

Rather than messing around with formulas and extra columns, recommend you try just using Categories to identify duplicates.

You can then "collapse" the rows and copy-paste the distinct values wherever you need them (or leave everything in place and delete the duplicate rows).

SG