Data Modeling & Programming with Excel: Conditional Formatting: & Custom Formats:

Need help with the questions below:

DATA

Employees *Apply a red text format to the top 12% of all salaries *Design and apply Conditional Formatting that applies a yellow fill color and a red text color to the entire row if the age value is greater than the selected value in cell L2 *Design and apply Conditional Formatting that applies a light green fill to those cells that match to value selected in cell M2 *Design and apply Custom Formatting that adds the words Young, Middle and Old to those values in the Age column according to: Less than 30 - Young, 30 to 50 - Middle, Over 50 - Old M2 v ft A I J K N O P A A ID H Age L M Target Age Department 25 A B Last Name 1 Abercrombie 2 Ackerman 3 Ajenstat 4 Akers 5 Alberts 6 Alderson 7 Alexander 8 Anderson 9 Bacon Jr. 10 Bankert 11 Barbariol 12 Barnhill 13 Barr 14 Bashary 15 Beck 16 Ben-Sachar 17 Benson 18 Berge 19 Berglund 20 Berndt 21 Berry 22 Bolender 23 Bonifaz 24 Boseman 25 Boseman 26 Bourne 27 Bourne 28 Bradley 29 Bradley 30 Bradley 31 Bready 32 Bremer Instructions C D First Name Date of Hire Date of Birth Department Kim 6/24/85 10/16/62 Pilar 4/26/89 10/5/50 Franois 2/1/81 12/21/64 Kim 5/29/79 4/8/58 Amy E. 10/15/89 4/22/70 Gregory F. (Greg) 1/12/92 5/28/64 Sean P 7/6/00 10/16/62 Nancy 6/6/86 6/20/76 Dan K. 4/6/88 1/14/61 Julie 4/21/83 11/24/77 Angela 2/16/96 4/18/64 Josh 7/26/77 10/12/54 Adam 7/9/93 4/8/59 Shay 3/14/95 1/30/72 Bradley 12/20/98 2/5/58 Ido 9/21/93 7/12/56 Max 11/22/77 9/2/75 Karen 6/1/97 2/27/65 Andreas 3/19/88 10/21/54 Matthias 3/17/91 1/28/78 9/20/00 1/7/66 Corinna 8/20/98 11/18/51 Luis 6/10/96 4/4/68 Randall 10/18/76 4/2/71 Randall 6/3/86 11/13/63 Stephanie 1/18/86 9/10/53 Stephanie 3/30/77 6/5/51 David M. 2/3/86 1/3/72 David M. 9/28/97 2/24/56 David M 7/13/84 2/28/54 Richard 12/22/84 6/11/56 7/4/89 3/26/59 Date Range Format Customer - First Purchase Employees + G Salary $91,000.00 $31,000.00 $48,000.00 $47,000.00 $60,000.00 $100,000.00 $29,000.00 $68,000.00 $85,000.00 $100,000.00 $92,000.00 $83,000.00 $66,000.00 $35,000.00 $70,000.00 $57,000.00 $97,000.00 $35,000.00 $93,000.00 $48,000.00 $76,000.00 $43,000.00 $77,000.00 $74,000.00 $55,000.00 $82,000.00 $33,000.00 $65,000.00 $50,000.00 $33,000.00 $27,000.00 $99,000.00 46 48 46 Ted 43 Employees *Apply a red text format to the top 12% of all salaries *Design and apply Conditional Formatting that applies a yellow fill color and a red text color to the entire row if the age value is greater than the selected value in cell L2 *Design and apply Conditional Formatting that applies a light green fill to those cells that match to value selected in cell M2 *Design and apply Custom Formatting that adds the words Young, Middle and Old to those values in the Age column according to: Less than 30 - Young, 30 to 50 - Middle, Over 50 - Old M2 v ft A I J K N O P A A ID H Age L M Target Age Department 25 A B Last Name 1 Abercrombie 2 Ackerman 3 Ajenstat 4 Akers 5 Alberts 6 Alderson 7 Alexander 8 Anderson 9 Bacon Jr. 10 Bankert 11 Barbariol 12 Barnhill 13 Barr 14 Bashary 15 Beck 16 Ben-Sachar 17 Benson 18 Berge 19 Berglund 20 Berndt 21 Berry 22 Bolender 23 Bonifaz 24 Boseman 25 Boseman 26 Bourne 27 Bourne 28 Bradley 29 Bradley 30 Bradley 31 Bready 32 Bremer Instructions C D First Name Date of Hire Date of Birth Department Kim 6/24/85 10/16/62 Pilar 4/26/89 10/5/50 Franois 2/1/81 12/21/64 Kim 5/29/79 4/8/58 Amy E. 10/15/89 4/22/70 Gregory F. (Greg) 1/12/92 5/28/64 Sean P 7/6/00 10/16/62 Nancy 6/6/86 6/20/76 Dan K. 4/6/88 1/14/61 Julie 4/21/83 11/24/77 Angela 2/16/96 4/18/64 Josh 7/26/77 10/12/54 Adam 7/9/93 4/8/59 Shay 3/14/95 1/30/72 Bradley 12/20/98 2/5/58 Ido 9/21/93 7/12/56 Max 11/22/77 9/2/75 Karen 6/1/97 2/27/65 Andreas 3/19/88 10/21/54 Matthias 3/17/91 1/28/78 9/20/00 1/7/66 Corinna 8/20/98 11/18/51 Luis 6/10/96 4/4/68 Randall 10/18/76 4/2/71 Randall 6/3/86 11/13/63 Stephanie 1/18/86 9/10/53 Stephanie 3/30/77 6/5/51 David M. 2/3/86 1/3/72 David M. 9/28/97 2/24/56 David M 7/13/84 2/28/54 Richard 12/22/84 6/11/56 7/4/89 3/26/59 Date Range Format Customer - First Purchase Employees + G Salary $91,000.00 $31,000.00 $48,000.00 $47,000.00 $60,000.00 $100,000.00 $29,000.00 $68,000.00 $85,000.00 $100,000.00 $92,000.00 $83,000.00 $66,000.00 $35,000.00 $70,000.00 $57,000.00 $97,000.00 $35,000.00 $93,000.00 $48,000.00 $76,000.00 $43,000.00 $77,000.00 $74,000.00 $55,000.00 $82,000.00 $33,000.00 $65,000.00 $50,000.00 $33,000.00 $27,000.00 $99,000.00 46 48 46 Ted 43