Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Date Product Region Amount 4/9/2019 Dairy Denmark 1 5/26/2019 Produce Denmark 1 12/7/2019 Produce Denmark 1 Denmark TCI 11/5/2019 Dairy Finland 7/12/2019 Dairy Finland 6/2/2019
Date Product Region Amount 4/9/2019 Dairy Denmark 1 5/26/2019 Produce Denmark 1 12/7/2019 Produce Denmark 1 Denmark TCI 11/5/2019 Dairy Finland 7/12/2019 Dairy Finland 6/2/2019 Grain Finland 1 Finland Tot 8/30/2019 Dairy Germany 7/26/2019 Dairy Germany 9/24/2019 Grain Germany 10/30/2019 Grain Germany 8/26/2019 Grain Germany 7/7/2019 Grain Germany 6/26/2019 Produce Germany 7/7/2019 Produce Germany Germany TCI 118/2019 Dairy Italy 1 2/13/2019 Dairy Italy 12/18/2019 Produce Italy 1 3/13/2019 Produce Italy Italy Total 1 1.148.00 1,530.00 1,423.50 4,101.50 192.10 351.00 560.40 1.103.50 470.00 17.40 1,405.00 470.00 17.40 747.00 17.40 747.00 3.891.20 3,194.20 438.43 3,194.20 438.43 7.265.26 Required 1. Format the values in the Amount column as Currency (Euro) with two decimal places. 2. Format the Date Column with Light Red Fill with Dark Red Text for dates that are occuring this month. 3. Format the Product Column with Yellow Fill with Dark Yellow Text for those cells that contain Grain. 4. Format the Amount Column with a Green Fill for those cells that are less than 500 euro
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started