After entering numbers in cells in Apple Numbers app, I need some way to run a script, macro of something to mark all cells that have a match, for instance giving the cell background a color.
All cells that have a matching number in another cell will change the cell color or yellow.
Turns out this functionality apparently (somehow) does not exist nor achievable in Apple Numbers natively - how that need was omitted is beyond me.
That said, someone created a service plugin for numbers that flags duplicates. The flag will highlight duplicates, however only the duplicates so it still requires hunting out its paIred duplicate value in my case…and that is fine and I appreciate the plug in.
For anyone in the future finding this post, here is a link to the thread and plug-in. Plug in works as of 01/15/2023.