4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees should have a hiring date between 1/1/1985 and 1/1/1990, both dates inclusive. (Hint: For dates, use # signs, example, #1/1/1985#) (Must use Do-Until loop). Create macro button in Database sheet.

Please provide formula(s)/steps necessary for solving this problem. Thank you!

A B D E F H K M Emp ID 1011 Birth Date 11/21/64 12294 9/21/95 8/9/87 Years in Service 21 15 19 Age 56 36 55 33 53 Division Copiar Printer Printer Copiar Coplor Printer Printer Printer Copiar 1012 1041 1054 1055 1075 1152 1153 1167 12 22 First Name Hazel Liza Robert Howard Madine Sheryl Mark Allan Sam Toni Joramy Linda 14 21 57 50 50 12 20 Fax Copier 1169 1199 1290 1299 1300 1301 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Last Name Gorton Preston Tercan Smith Albert Kane Henders Plant Barwick Asonte Dorfberg Cooper Simpson Richards Sindole Smith Cane Vuando Solznick Cash Szcznyck Kanako Lampstone Ball Quan 16 15 35 55 Fax Copiar Printer Fax Department Accounting Engineering Rand D Art Marketing Art Accounting Accounting Marketing Engineering Engineering Admin Engineering Accounting Marketing Engineering Marketing Engineering Accounting Engineering Engineering Rand D Marketing Accounting Engineering Engineering Admin Rand D Engineering Admin Salary $27 597 85 $43,394.15 $28.043.00 $25.170.00 $26.040.56 $23.239.44 $26.646.20 $28.043.00 $31.913.80 $63,035.89 $58,002.05 $26.113.96 $34,85420 $30,451.60 $27,081.04 $32.410.45 $43.496.95 $55.410.95 $31,539.24 $49.872.15 $59.382.20 $28,043.68 $64,699.00 $28,549.50 $75,599.00 $45, 146.68 $25, 146.68 $41,053.49 $29.382.20 $27,081.04 Hire Date 2300 1/2606 4/16/02 4/16/09 48/99 8/7106 1/21/00 1/13/09 4/18/01 4/10/99 10/13799 1/3/05 12/21/05 12/13193 86/08 101496 9/26/02 2/22/09 2/14/99 5/11/99 4/16/95 4/8/98 91995 31604 2126799 1/29/07 1/20/91 5/11/96 11/26/05 8/18/09 8/20167 8/29/79 10/23/71 11/3/63 9/29/70 710/70 7/12/70 10/1/06 9/16/95 912465 6/26461 11/295 11/13/54 5664 9/23/68 5/21/64 10/7165 10/18/65 9/23/58 6/26163 7/7/63 59 12 New Salary1 New Salary 2 Birth Month $30,281.74 $30,909.59 Nov $43,394.15 $47,082.65 Dec $29,796.41 $31,408.92 Sep $25,176.06 $28,197.19 Aug $28,573.00 $29,165.43 Aug $23,239.44 $26,028.17 Aug $29,237.54 $29,843.74 Oct $28,043.68 $31,408.92 Nov $35,017.50 $35,743.55 Sep $69,166.12 $70,600.19 Jul $63,642.75 $ 64,962.30 Jul $27,745.98 $29,247.52 Oct $34,854.20 $37,816.81 Sep $33,413.11 $34,105.88 Sep $27,081.04 $29,382.93 Jun $35,562.81 $36,300.15 Nov $46,204.88 $48,705.38 Nov $55,410.85 $60,120.77 May $34,606.43 $35,323.95 Sep $54,722.22 $55,856.81 May $65,135.17 $66,485.66 Oct $30,770.93 $31,408.92 Oct $70,980.01 $72,451.68 Sep $30,333.84 $31,975.44 Jun $82,940.69 $84,660.35 Jul $45, 146.68 $48,984.15 Sep $27,592.19 $28,164.28 Jan $45,045.93 $45,979.90 Jan $29,362.20 $31,857.99 Sep $27,081.04 $30,330.76 Mar 1310 Fax 55 34 18 Sandra Phillip Randy Ellen Nate Tuoma Anna Mary Tadeuz Midori Pote Tom Karan Tommia lain Alexandra Karen 1311 1329 1330 12 52 21 55 1331 1333 1334 1426 25 23 55 62 35 Printer Printer Copiar Printer Copiar Fax Fax Printer Printer Printer Printer Copior Printer Copiar 17 1516 1517 1529 57 57 32 49 1530 30 1531 1536 Kallarman Stewart Lempert Davison Bates 9/10/71 1/1567 1/1967 9/23187 3122190 54 33 31 14 1557 Lisa 11 B D E F G H - J L M 25 1558 1657 1674 1675 1675 1676 1677 1723 1724 Marketing Accounting Accounting Accounting Marketing Admin Rand D Engineering Marketing 10/1605 126/02 312506 3/17/96 10/26/98 10/1801 11/6/07 8/6/98 19 13 7129197 12/2407 12/16/03 23 13 1792 9/26,82 10/10183 1/17190 1/2964 9/1/99 9/1282 9/16/99 9123165 5/21/65 10/3168 10/14/76 10/18/96 9/29/99 9/1/99 44 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 17 34 Sargent Walls Boughton Molandez Miller Walls Levine Alstain Chu Barton Abla Goldberg A-Sabah Lin Mueller Fontaine Mueller Corwick Aruda Martinez Franklin Petry Maguire Silverberg Evelyn Rose Frank Jaime Janet Jason Eric Isolde Steven Eileen Aaron Malcolm Daoud Michael Ursula Joan Kris Rob Folica Sara Larry Robin Mollie Jay Copior Printer Fax Fax Copiar Copiar Fax Fax Printer Copier Fax Fax Faxc Fax Copier Copier Fax Fax Copior Copier Copier Printer Copiar Fax 899 388 49 3 &&&99 98 $41,987.40 $32,626.90 $27.597.85 $29.045.24 $33,301.44 $23.212.32 $37.995.52 $89.382.20 $28.043.68 $28,959.25 $24,179.50 $57.489.75 $51,303.60 $35,490.40 $36,101.44 $28,043.68 $27.091.04 $23.239.44 $23 212.32 $35.999 20 $21.997.95 $33,035.88 $30.013.62 $51.878.84 Admin Marketing Engineering Engineering Accounting Aco Admin 2/18/08 34/92 13 29 E BE=e = = 1793 1794 1814 1816 1931 1990 1961 1996 1967 1968 1975 1976 1977 1978 $44,611.61 $47,025.89 Sep $34,665.98 $36,542.02 Oct $27,597.85 $30,909.59 Jan $31,869.89 $32,530.67 Jan $36,540.01 $37,297.61 Sep $25,469.72 $25,997.80 Sep $37,895.52 $41,116.64 Sep $76,107.67 $77,685.66 Sep $30,770.93 $31,408.92 May $28,859.25 $32,322.36 Oct $25,690.72 $27,081.04 Oct $57,488.75 $62,375.29 Oct $56,292.88 $57,460.03 Sep $37,697.93 $39,738.05 Sep $36, 101.44 $40,433.61 May $30,770.93 $31,408.92 Mar $27,081.04 $30,330.76 Apr $25,499.48 $26,028.17 May $25,469.72 $25,997.80 May $39,489.15 $40,307.90 May $24,016.55 $24,514.50 Sep $36,248.62 $37,000.19 Oct $32,932.44 $33,615.25 Sep $51,878.84 $56,288.54 Oct 718/02 5/28186 34 6/20/09 11/13/92 11,506 18 11 29 312265 412165 5499 14 Admin Marketing Accounting Engineering 11/17/91 11/9/91 1/1/93 5/7/97 4/29/01 6/1300 1/508 5/15/09 5/1999 9/28/70 10/9/79 41 29 23 20 20 13 39 9/21/81 10/18191 Engineering 29 A B D E F H K M Emp ID 1011 Birth Date 11/21/64 12294 9/21/95 8/9/87 Years in Service 21 15 19 Age 56 36 55 33 53 Division Copiar Printer Printer Copiar Coplor Printer Printer Printer Copiar 1012 1041 1054 1055 1075 1152 1153 1167 12 22 First Name Hazel Liza Robert Howard Madine Sheryl Mark Allan Sam Toni Joramy Linda 14 21 57 50 50 12 20 Fax Copier 1169 1199 1290 1299 1300 1301 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Last Name Gorton Preston Tercan Smith Albert Kane Henders Plant Barwick Asonte Dorfberg Cooper Simpson Richards Sindole Smith Cane Vuando Solznick Cash Szcznyck Kanako Lampstone Ball Quan 16 15 35 55 Fax Copiar Printer Fax Department Accounting Engineering Rand D Art Marketing Art Accounting Accounting Marketing Engineering Engineering Admin Engineering Accounting Marketing Engineering Marketing Engineering Accounting Engineering Engineering Rand D Marketing Accounting Engineering Engineering Admin Rand D Engineering Admin Salary $27 597 85 $43,394.15 $28.043.00 $25.170.00 $26.040.56 $23.239.44 $26.646.20 $28.043.00 $31.913.80 $63,035.89 $58,002.05 $26.113.96 $34,85420 $30,451.60 $27,081.04 $32.410.45 $43.496.95 $55.410.95 $31,539.24 $49.872.15 $59.382.20 $28,043.68 $64,699.00 $28,549.50 $75,599.00 $45, 146.68 $25, 146.68 $41,053.49 $29.382.20 $27,081.04 Hire Date 2300 1/2606 4/16/02 4/16/09 48/99 8/7106 1/21/00 1/13/09 4/18/01 4/10/99 10/13799 1/3/05 12/21/05 12/13193 86/08 101496 9/26/02 2/22/09 2/14/99 5/11/99 4/16/95 4/8/98 91995 31604 2126799 1/29/07 1/20/91 5/11/96 11/26/05 8/18/09 8/20167 8/29/79 10/23/71 11/3/63 9/29/70 710/70 7/12/70 10/1/06 9/16/95 912465 6/26461 11/295 11/13/54 5664 9/23/68 5/21/64 10/7165 10/18/65 9/23/58 6/26163 7/7/63 59 12 New Salary1 New Salary 2 Birth Month $30,281.74 $30,909.59 Nov $43,394.15 $47,082.65 Dec $29,796.41 $31,408.92 Sep $25,176.06 $28,197.19 Aug $28,573.00 $29,165.43 Aug $23,239.44 $26,028.17 Aug $29,237.54 $29,843.74 Oct $28,043.68 $31,408.92 Nov $35,017.50 $35,743.55 Sep $69,166.12 $70,600.19 Jul $63,642.75 $ 64,962.30 Jul $27,745.98 $29,247.52 Oct $34,854.20 $37,816.81 Sep $33,413.11 $34,105.88 Sep $27,081.04 $29,382.93 Jun $35,562.81 $36,300.15 Nov $46,204.88 $48,705.38 Nov $55,410.85 $60,120.77 May $34,606.43 $35,323.95 Sep $54,722.22 $55,856.81 May $65,135.17 $66,485.66 Oct $30,770.93 $31,408.92 Oct $70,980.01 $72,451.68 Sep $30,333.84 $31,975.44 Jun $82,940.69 $84,660.35 Jul $45, 146.68 $48,984.15 Sep $27,592.19 $28,164.28 Jan $45,045.93 $45,979.90 Jan $29,362.20 $31,857.99 Sep $27,081.04 $30,330.76 Mar 1310 Fax 55 34 18 Sandra Phillip Randy Ellen Nate Tuoma Anna Mary Tadeuz Midori Pote Tom Karan Tommia lain Alexandra Karen 1311 1329 1330 12 52 21 55 1331 1333 1334 1426 25 23 55 62 35 Printer Printer Copiar Printer Copiar Fax Fax Printer Printer Printer Printer Copior Printer Copiar 17 1516 1517 1529 57 57 32 49 1530 30 1531 1536 Kallarman Stewart Lempert Davison Bates 9/10/71 1/1567 1/1967 9/23187 3122190 54 33 31 14 1557 Lisa 11 B D E F G H - J L M 25 1558 1657 1674 1675 1675 1676 1677 1723 1724 Marketing Accounting Accounting Accounting Marketing Admin Rand D Engineering Marketing 10/1605 126/02 312506 3/17/96 10/26/98 10/1801 11/6/07 8/6/98 19 13 7129197 12/2407 12/16/03 23 13 1792 9/26,82 10/10183 1/17190 1/2964 9/1/99 9/1282 9/16/99 9123165 5/21/65 10/3168 10/14/76 10/18/96 9/29/99 9/1/99 44 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 17 34 Sargent Walls Boughton Molandez Miller Walls Levine Alstain Chu Barton Abla Goldberg A-Sabah Lin Mueller Fontaine Mueller Corwick Aruda Martinez Franklin Petry Maguire Silverberg Evelyn Rose Frank Jaime Janet Jason Eric Isolde Steven Eileen Aaron Malcolm Daoud Michael Ursula Joan Kris Rob Folica Sara Larry Robin Mollie Jay Copior Printer Fax Fax Copiar Copiar Fax Fax Printer Copier Fax Fax Faxc Fax Copier Copier Fax Fax Copior Copier Copier Printer Copiar Fax 899 388 49 3 &&&99 98 $41,987.40 $32,626.90 $27.597.85 $29.045.24 $33,301.44 $23.212.32 $37.995.52 $89.382.20 $28.043.68 $28,959.25 $24,179.50 $57.489.75 $51,303.60 $35,490.40 $36,101.44 $28,043.68 $27.091.04 $23.239.44 $23 212.32 $35.999 20 $21.997.95 $33,035.88 $30.013.62 $51.878.84 Admin Marketing Engineering Engineering Accounting Aco Admin 2/18/08 34/92 13 29 E BE=e = = 1793 1794 1814 1816 1931 1990 1961 1996 1967 1968 1975 1976 1977 1978 $44,611.61 $47,025.89 Sep $34,665.98 $36,542.02 Oct $27,597.85 $30,909.59 Jan $31,869.89 $32,530.67 Jan $36,540.01 $37,297.61 Sep $25,469.72 $25,997.80 Sep $37,895.52 $41,116.64 Sep $76,107.67 $77,685.66 Sep $30,770.93 $31,408.92 May $28,859.25 $32,322.36 Oct $25,690.72 $27,081.04 Oct $57,488.75 $62,375.29 Oct $56,292.88 $57,460.03 Sep $37,697.93 $39,738.05 Sep $36, 101.44 $40,433.61 May $30,770.93 $31,408.92 Mar $27,081.04 $30,330.76 Apr $25,499.48 $26,028.17 May $25,469.72 $25,997.80 May $39,489.15 $40,307.90 May $24,016.55 $24,514.50 Sep $36,248.62 $37,000.19 Oct $32,932.44 $33,615.25 Sep $51,878.84 $56,288.54 Oct 718/02 5/28186 34 6/20/09 11/13/92 11,506 18 11 29 312265 412165 5499 14 Admin Marketing Accounting Engineering 11/17/91 11/9/91 1/1/93 5/7/97 4/29/01 6/1300 1/508 5/15/09 5/1999 9/28/70 10/9/79 41 29 23 20 20 13 39 9/21/81 10/18191 Engineering 29