Guest User

Untitled

a guest
Nov 12th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. use N : application "Numbers"
  2. --------------------------------------------------------------------------------
  3. # PROPERTY VALUES & GLOBAL VARIABLES
  4. property document : a reference to document 1 of N
  5. property sheet : a reference to active sheet of my document
  6. property table : a reference to table 1 of my sheet
  7.  
  8. global them
  9. --------------------------------------------------------------------------------
  10. # IMPLEMENTATION:
  11. on run
  12. if not (exists my table) then return false
  13.  
  14. set them to a reference to (every row of my table ¬
  15. where the value of cell 1 = the value of cell 2 ¬
  16. and the value of cell 1 ≠ missing value)
  17.  
  18. highlight()
  19. ---OR:
  20. -- comment()
  21. --OR:
  22. -- delete -- WARNING: permanent!
  23. end run
  24. --------------------------------------------------------------------------------
  25. # HANDLERS:
  26. to highlight()
  27. set the background color of them to ¬
  28. {65535, 65535 / 4, 65535 / 2}
  29. end highlight
  30.  
  31. to delete
  32. delete them
  33. end delete
  34.  
  35. to comment()
  36. set the value of cell 3 of them to "SNAP!"
  37. end comment
  38. ---------------------------------------------------------------------------❮END❯
Add Comment
Please, Sign In to add comment