Question: Please help, i am using office 360. Please show all the steps and formulas. Thank you! A B D E F G H 1 2
Please help, i am using office 360. Please show all the steps and formulas. Thank you!

A B D E F G H 1 2 3 Summary Total Debits Total Credits Diff 4 5 $25,853.00 $25,853.00 $0.00 6 7 8 Telephone Expense Allocation 9 10 Credit 11 12 13 14 15 16 17 18 19 20 21 22 23 Account Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Department Comments Operations To allocate telco by cell number Research To allocate telco by cell number Manufacturing To allocate telco by cell number Sales To allocate telco by cell number Marketing To allocate telco by cell number Logistics To allocate telco by cell number IT To allocate telco by cell number Warehouse To allocate telco by cell number Accounting To allocate telco by cell number Corporate To allocate telco by cell number Debit $3,750.82 $2,120.97 $1,297.83 $12,725.13 $1,982.20 $125.25 $2,207.85 $497.20 $1,145.75 $25,853.00 Required: 1. Format the Diff value with Green Fill with Dark Green Text if the value equals 0. 2. Format the Diff value with Light Red Fill with Dark Red Text if the value does not equal O. A B D E F G H 1 2 3 Summary Total Debits Total Credits Diff 4 5 $25,853.00 $25,853.00 $0.00 6 7 8 Telephone Expense Allocation 9 10 Credit 11 12 13 14 15 16 17 18 19 20 21 22 23 Account Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Department Comments Operations To allocate telco by cell number Research To allocate telco by cell number Manufacturing To allocate telco by cell number Sales To allocate telco by cell number Marketing To allocate telco by cell number Logistics To allocate telco by cell number IT To allocate telco by cell number Warehouse To allocate telco by cell number Accounting To allocate telco by cell number Corporate To allocate telco by cell number Debit $3,750.82 $2,120.97 $1,297.83 $12,725.13 $1,982.20 $125.25 $2,207.85 $497.20 $1,145.75 $25,853.00 Required: 1. Format the Diff value with Green Fill with Dark Green Text if the value equals 0. 2. Format the Diff value with Light Red Fill with Dark Red Text if the value does not equal O
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
