You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Conditional highlight in numbers

How do I set up a conditional highlight in numbers for a duplicate number or name. could do this in Excel having trouble with numbers iMac

Posted on Feb 10, 2020 11:00 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 10, 2020 2:59 PM

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

6 replies
Question marked as Top-ranking reply

Feb 10, 2020 2:59 PM in response to Plantfoot too

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

Conditional highlight in numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.