I ran across a great script to highlight the top 3 values in a Numbers column in the following post.
https://discussions.apple.com/thread/7555832
Is there a way to modify the script to ALSO highlight the bottom 3 values? Any help would be much appreciated.
MacBook Pro 13", 10.14
Somehow when pasting the code each line ended up with an empty line after it.
Just eliminate the extra empty lines and it works.
It is not difficult, given the code you already have.
You have determined the high values, now you need to do the same for the low values.
The following code just takes what you had and does it analogously for the lowest values.
I tested it and it worked, but of course it comes "as is", with no warranty whatsoever.
Test on a copy of your documents, to be safe.
--------- paste the code below into a script in Script Editor or an Applescript action in Automator -----------
Thank so much for taking a look at this Luis. I ran the script and hit this alert. Thoughts? I tried deleted "repeat," but then the error moved to the next line, expecting an "Else" instead of a "Tell".
Thank you! That did the trick. It works great!
Using scripting to highlight cells in Numbers
