Ungroup the worksheets and ensure the Employee_Info worksheet is active. Click cell G6 and enter a nested logical function that calculates employee 401K eligibility. If the employee is full time (FT) and was hired before the 401k cutoff date 1/1/19, then he or she is eligible and Y should be displayed, non-eligible employees should be indicated with a N. Be sure to utilize the date located in cell H3 as a reference in the formula. Use the fill handle to copy the function down completing the range G6:G25.I'm not sure which formula to use or the steps i should take to complete FileHomeInsertDrawPage LayoutFormulasDataReviewViewDeveloperHelp8 Sharer ΣfrA Recently Used A TextZ AutoSum2 Logical -B, Trace PrecedentsTrace Dependents AF Remove Arrows -O Lookup & ReferenceO Define Name vO Math & Trig<2 Use in Formula v-InsertFunction e Financial vNameWatchCalculationO Date & Time v E More FunctionsManager Create from SelectionEWindowOptionsFunction LibraryDefined NamesFormula AuditingCalculationB11fe1/21/2019ABDEFGHKLM1 Tech Store Unlimited23 Employee Information1/1/2019401K Cut Of4Employee LookupEmployee_ID5 Employee_II Start_Date First_Name Last_Name Type Dependent 401k Eligible Salary2/1/2017 NelsonDependents631461GailFT##########56768 8/19/2020 Lopez1/8/2017 Ramsey7VivianET###H =831428Matthew FT#########2#$ 85,000.00$ 95,000.00$ 18,864.00$ 23,722.00Employee Lookup FilterEmployee_ID9462742/2/2017 Stevenson BeverlyFT3Dependent Salary4/29/2020 Smith43482 1/21/2019|Kelley1030261PeterFTТуреEmilyPhyllis11PT212886965/1/2021 CarrollPT3$ 14,966.00$ 18,751.00$ 18,875.00$ 11,513.00$ 20,044.00$ 10,354.00$ 11,049.00$ 24,010.00$ 11,156.00$ 23,142.00$ 12,105.00$ 24,905.00$ 10,663.0013650301/28/2018 HuntBarbaraEmployee StatisticsPT1498674 12/29/2018 AustinMelanie PT4# PT1598065 10/14/2020 SnyderJeanPT1Total PT SalariesAverage PT SalaryHighest PT Salary16800876/4/2020 MorrisSuzanne PT1779886 6/15/2018 GibsonGeraldine PT186440111/3/2021 GrahamVickiPT3# FT1972922 12/15/2021 WatsonMarilynPT4Total FT Salaries5/30/2019 Simpson Troy1/14/2020 Barber2090871PTAverage FT Salary2139948AaronPT4Highest FT Salary224072512/7/2020 MoralesBrittanyPT323429881/31/2019 BlairCynthiaPT34/13/2018 Jennings Dolores4/29/2018 Carroll2440499PT2528253HowardPT326272820

Actually, given information Ungroup the worksheets and ensure the Employee Info worksheet is active. Click cell G6 and enter a nested logical function that calculates employee 401K eligibility. If the employee is full time (FT) and was hired before the 401k cutoff date 1/1/19, then he or she is eligible and Y should be displayed, non-eligible employees should be indicated with a N. Be sure to utilize the date located in cell H3 as a reference in the formula. Use the fill handle to copy the function down completing the range G6:G25.Employee_Info worksheet Employee 401K Eligibility - The condition to be used in G6 is =IF(AND(E6="FT",B6<$H$3),"Y","N") Since for every calculation of 401K eligibility we want to refer to same Cell H3, we make it status using $ symbol as $H$3 Now we can drag the fill handle from G6 till G25 and for G7 the formula would become =IF(AND(E7="FT",B7<$H$3),"Y","N") for G8 =IF(AND(E8="FT",B8<$H$3),"Y","N") and so on. Note H3 remains constant and does not become H4, H5 or I3, J3 TO apply conditional formatting, select Cells G6 to G25 and click on Quick Analysis Under Formatting , click on Text that contains and enter details as below in the pop up