Page 1 of 1
А B с D E F G Last First Name Name Date Hired Vacation Days Salary Flex Time Tanner Joyce 9/24/1997 10 $1,000 yes Anthon
Posted: Fri May 20, 2022 5:11 pm
by answerhappygod
- 1 (207.76 KiB) Viewed 36 times
А B с D E F G Last First Name Name Date Hired Vacation Days Salary Flex Time Tanner Joyce 9/24/1997 10 $1,000 yes Anthony Ken 5/15/1995 9 $2,000 yes Clifton Katherine 6/8/1996 8 $3,000 yes Employeeld 1 2 JTAN 3 KANT 4 KCLI 5 6 7 JPAO 8 WCHA 9 10 RALV 11 CKNI 12 13 RRIV 14 DSMI 15 RALV 16 Totals Paolucci Jennifer Chan Wei 7/7/1994 3/23/1995 7 $4,000 no 6 $5,000 no Alverez Rosa Knight Carolyn 8/28/1996 4/15/1994 5 $6,000 no 4 $7,000 yes Rivera Rubin Smith Donald Sharet Bells 11/1/1991 10/25/1996 7/8/1996 3 $8,000 yes 2 $9,000 yes 1 $10,000 no 55 $55,000 Sub AFDO i = 10 k= 5 If Cells(i, k).Value = 5 Then Cells(i, k).Font.Color = vbRed Else Cells(i + 1, k + 1).Font.Color = vbGreen End Sub Salary $7,000 is in green font O Salary $7,000 is in red font Vacation Days 5 is in green font Vacation Days 5 is in red font None of the above are correct