You are ready to calculate the total costs and use conditional logic and formatting.

1. Ensure the Current worksheet is active. Click cell G6 and enter a nested logical function that calculates employee Bonus eligibility. If the employee has a college degree YES and was hired before the cutoff date of 6/19/19 (cell H3), then he or she is eligible, and Y should be displayed; non-eligible employees should be indicated with an N.

1. Use the fill handle to copy the function down without formatting, completing the range G6:G25.

1. Apply conditional formatting to the range G6:G25 that highlights eligible employees with Light Red Fill with Dark Red Text color. Save the workbook.