I would like to know how to – when I have a list, in Numbers,, of Lacrosse players & jersey numbers, I would like to be able to make the cell turn a color to indicate that a jersey number has already been selected..
Thank you!
I am simply attempting to have an alert to keep from repeating jersey numbers on a team – using Apple Numbers..
—–
JF Simms
Conditional Highlighting isn't the right tool for that job. It reacts to the value IN the cell, not values outside the cell.
Instead, have an additional column that uses an COUNTIF function to calculate how many times the value appears. So if the jersey numbers are in column J, then in column K you could have something like this (in row 2, for example):
IF(COUNTIF(J,J2)>1,"!!!!","")
So if the jersey number in J2 is present in column J more than once, then "!!!!" is in K2. Otherwise, K2 looks empty. Use anything you want in place of !!!!.
I have something like this shown in this video from a while back:
https://macmost.com/mac-numbers-conditional-highlighting-and-alternatives.html