[gcrump]

I know this is an older thread but here is the script that I cam up with to solve this problem. I am open to any ideas for improvement:

repeat with theRow in (every row whose state is unchecked)
set theDate to value of cell "Due Date" of theRow
if theDate is not missing value then
remove every named style of style of theRow from named styles of style of theRow
set myStyle to named style ("Overdue")
if theDate < TodaysDate then
add myStyle to named styles of style of theRow
else
remove myStyle from named styles of style of theRow
end if
else
-- missing value but unchecked (means I forgot to set a date)
remove every named style of style of theRow from named styles of style of theRow
set myStyle to named style ("Blankdue")
add myStyle to named styles of style of theRow
end if
end repeat