Spreadsheet Cell Format

Spreadsheet Cell format I need input formula to spreadsheet cells for auto data entry for various conditions to respective fields. Note: See examples in attached spreadsheet. The column A is for number entry. Upon input of a number (0-36) to Column A cell, shall automatically update the information to the corresponding cells in the Column B , C, etc…..onwards; under certain specific conditions. For example: When Cell A2 (No.) input a number from a set of numbers set as below, then Cell B2 (Red) specify that the number shall be reflected with a tick ( or such can be signify by a letter “V”) in cell B2. Column B (Red) Set of numbers for Column B cell marked with a tick ( “V”): Column C cell is left blank. 1, 3, 5, 7, 9, 12, 14, 16, 18, 19, 21, 23, 25, 27, 30, 32, 34, 36. Column C (Black) Set of numbers for Column C cell marked with a tick ( “V”): Column B cell is left blank. 2, 4, 6, 8, 10, 11, 13, 15, 17, 20, 22, 24, 26, 28, 29, 31, 33, 35. For number input of “0”, Column B cell and C cell shall reflect a “O”. ---- Column D (Even) Set of numbers for Column D cell marked with a tick ( “V”): Column E cell is left blank. 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30, 32, 34, 36. Column E (Odd) Set of numbers for Column E cell marked with a tick ( “V”): Column D cell is left blank. 1, 3, 5, 7, 11, 13, 15, 17, 19, 21, 23, 25, 27, 29, 31, 33, 35. For number input of “0”, Column D cell and E cell shall reflect a “O”. ---- Column F (Big) Set of numbers for Column F cell marked with a tick ( “V”): Column G cell is left blank. 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36. Column F (Small) Set of numbers for Column G cell marked with a tick ( “V”): Column F cell is left blank. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18. For number input of “0”, Column F cell and G cell shall reflect a “O”. ---- Column H (Row123) Set of numbers for Column H cell marked with corresponding number: Entry No. – Input number Entry No. – Input Number Entry No. – Input Number Column A - Column H cell Column A - Column H cell Column A – Column H cell 0 0 1 1 2 2 3 3 4 1 5 2 6 3 7 1 8 2 9 3 10 1 11 2 12 3 13 1 14 2 15 3 16 1 17 2 18 3 19 1 20 2 21 3 22 1 23 2 24 3 25 1 26 2 27 3 28 1 29 2 30 3 31 1 32 2 33 3 34 1 35 2 36 3 Column I (Section123) Set of numbers for Column I cell marked with corresponding number: Entry No. – Input number Entry No. – Input Number Entry No. – Input Number Column A - Column I cell Column A - Column I cell Column A – Column I cell 0 0 1 1 13 2 25 3 2 1 14 2 26 3 3 1 15 2 27 3 4 1 16 2 28 3 5 1 17 2 29 3 6 1 18 2 30 3 7 1 19 2 31 3 8 1 20 2 32 3 9 1 21 2 33 3 10 1 22 2 34 3 11 1 23 2 35 3 12 1 24 2 36 3 ---- Column J (Top) Set of numbers for Column J cell marked with a tick ( “V”): 0, 2, 3, 4, 7, 12, 15, 17, 19, 21, 25, 26, 28, 29, 32, 35. For number input of 6, 9, 18, 22, 34 Column J cell shall reflect a “O”. ---- Column K (Bottom) Set of numbers for Column K cell marked with a tick ( “V”): 1, 5, 8, 10, 11, 13, 14, 16, 20, 23, 24, 27, 30, 31, 33, 36. For number input of 6, 9, 18, 22, 34 Column K cell shall reflect a “O”. ---- Column L (Left) Set of numbers for Column L cell marked with a tick ( “V”): 1, 3, 7, 9, 12, 14, 16, 18, 20, 22, 26, 28, 29, 31, 33, 35. For number input of 0, 5, 10, 24, 32 Column L cell shall reflect a “O”. ---- Column M (Right) Set of numbers for Column M cell marked with a tick ( “V”): 2, 4, 6, 8, 11, 13, 15, 17, 19, 21, 23, 25, 27, 30, 34, 36. For number input of 0, 5, 10, 24, 32 Column L cell shall reflect a “O”. ---- Column N (A) Set of numbers for Column N cell marked with a tick ( “V”): 0,3, 4, 7, 9, 12, 15, 18, 19, 22, 26, 28, 29, 31, 32, 35. For number input of 1, 2, 14, 20, 21 Column N cell shall reflect a “O”. ---- Column O (C) Set of numbers for Column O cell marked with a tick ( “V”): 5, 6, 8, 10, 11, 13, 16, 17, 23, 24, 25, 27, 30, 33, 34, 36. For number input of 1, 2, 14, 20, 21 Column O cell shall reflect a “O”. ---- Column P (B) Set of numbers for Column P cell marked with a tick ( “V”): 1, 5, 7, 9, 10, 14, 16, 18, 20, 22, 23, 24, 28, 29, 31, 33. For number input of 8, 11, 12, 30, 35 Column P cell shall reflect a “O”. ---- Column Q (D) Set of numbers for Column Q cell marked with a tick ( “V”): 0, 2, 3, 4, 6, 13, 15, 17, 19, 21, 25, 26, 27, 32, 34, 36. For number input of 8, 11, 12, 30, 35 Column Q cell shall reflect a “O”. ---- Column V (AL) Set of numbers for Column V cell marked with a tick ( “V”): 1, 2, 4, 5, 6, 7, 8, 9, 11, 13, 14, 16, 17, 18, 32, 35. For number input of 0, 10, 12, 19, 26 Column V cell shall reflect a “O”. ---- Column S (AR) Set of numbers for Column S cell marked with a tick ( “V”): 3, 15, 20, 21, 22,23, 24, 25, 27, 28, 29, 30, 31, 33, 34, 36. For number input of 0, 10, 12, 19, 26 Column S cell shall reflect a “O”. ---- Column T (Riviera) Set of numbers for Column T cell marked with a tick ( “V”): 1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18. For number input of 0, 5, 10, 23, 24, 26, 32 Column T cell shall reflect a “O”. ---- Column U (MGM) Set of numbers for Column U cell marked with a tick ( “V”): 0, 1, 2, 7, 8, 10, 12, 16, 17, 19, 22, 26, 27, 31, 32, 36. ---- Column V (Duo A) Set of numbers for Column V cell marked with a tick ( “V”): 0, 1, 3, 4, 5, 8, 10, 15, 16, 19, 23, 24, 26, 32, 33, 35, For number input of 11, 12, 20, 21, 30 Column V cell shall reflect a “O”. ---- Column W (Duo B) Set of numbers for Column W cell marked with a tick ( “V”): 2, 6, 7, 9, 13, 14, 17, 18, 22, 25, 27, 28, 29, 31, 34, 36. For number input of 11, 12, 20, 21, 30 Column W cell shall reflect a “O”. ---- Column X (Tri A) Set of numbers for Column X cell marked with a tick ( “V”): 0, 1, 3, 6, 9, 11, 13, 14, 15, 20, 26, 27, 31, 32, 33, 36. For number input of 16, 19, 22, 34, 35 Column X cell shall reflect a “O”. ---- Column Y (Tri B) Set of numbers for Column Y cell marked with a tick ( “V”): 2, 4, 5, 7, 8, 10, 12, 17, 18, 21, 23, 24, 25, 28, 29, 30. For number input of 16, 19, 22, 34, 35 Column Y cell shall reflect a “O”. ---- Column Z (4A-Stars) Set of numbers for Column Z cell marked with a tick ( “V”): 0, 3, 5, 6, 9, 10, 17, 18, 22, 23, 24, 26, 27, 31, 32, 34. For number input of 13, 15, 16, 25, 29 Column Z cell shall reflect a “O”. ---- Column AA (4B-Stars) Set of numbers for Column AA cell marked with a tick ( “V”): 1, 2, 4, 7, 8, 11, 12, 14, 19, 20, 21, 28, 30, 33, 35, 36. For number input of 13, 15, 16, 25, 29 Column AA cell shall reflect a “O”. ----