Help with AppleScript to automate Numbers Cell Formatting
I finally got what I wanted. I used an app called Script Debugger 7, though not necessary, it really helped me with all the classes &amp; options available with each application and detailed help. 

Further, it was really easy to write scripts in this app. For anybody needing a similar solution, I hope this helps. This script is not the best, in terms of error checking or dynamic names, but that's for another day.

------Script below--------

property rBlue : {1721, 15020, 27788}
property rPink : {48626, 3448, 26715}

use AppleScript version "2.4" -- Yosemite (10.10) or later
use scripting additions


tell application "Numbers"
tell document 1
    tell active sheet
        tell table "Table 1"
            set rCount to get row count

            repeat with r from 2 to rCount
                set valCell to formatted value of cell ("A" &amp; r)
                set remCell to valCell mod 2

                if remCell = 0 then set text color of cell ("A" &amp; r) to rBlue
                if remCell ≥ 1 then set text color of cell ("A" &amp; r) to rPink
            end repeat

        end tell
    end tell
end tell

end tell