Applescript: How to test if a cell is empty in Numbers?

The test you want to do is for missing value. I've added to your script to exclude empty cells having their background colour set to red, and commented-out an else to colour all empty cells green instead.

The other thing to note is that there's now an intermediate step where cv becomes first the value of the cell (and is then tested for missing value) and then to the text string of its value.

tell application "Numbers" to tell front document to tell active sheet

set selected_table to first table whose class of selection range is range

tell selected_table

set selected_range to the selection range

tell selected_range

set values_list to {}

repeat with i from 1 to count cells

set cv to value of cell i

if cv is not missing value then --if the cell is empty skip it

set cv to cv as text

if values_list contains (cv) then set background color of cell i to "red"

set end of values_list to value of cell i as text

--else --optionally colour green by uncommenting these lines

--set background color of cell i to "green"

end if

end repeat

end tell

end tell

end tell

Thanks for pointing out the blank cells issue.

My style has evolved a bit since posting that original script/service over on the Numbers for Mac discussions last year.

Now I'd simply do a shorter script as below...

SG

tell application "Numbers" to tell front document to tell active sheet

set t to first table whose selection range's class is range

set selRng to t'sselection range

set vv to {missing value}

repeat with i from 1 to (count selRng's cells)

tell selRng's cell i

if its value is not in vv then

copy its value to end of vv

else

if its value is not missing value then set its background color to "red"

end if

end tell

end repeat

end tell