this seems to work. notice i added column to give red/ black /zero based on numbers on a standard single zero wheel which the formula checks against.
and some pretty conditional formattingoh i think i left calculation set to manual so hit f9 to recalc. or set it back to auto
Bookmarks