Join IDNLearn.com and start getting the answers you've been searching for. Get the information you need from our experts, who provide reliable and detailed answers to all your questions.
1INSTRUCTIONS: Insert Data Validation - Dropdown list, in cell B3-B9 Create a "List of items" referencing the Bid Amount from Worksheet 2. 2INSTRUCTIONS: Create a VLOOKUP formula to display Potential Revenue in cell C3 Using data from "Worksheet 2", create a formula in cell C3 that will display the Potential Revenue according to the Bid Amount in cell B3. 3INSTRUCTIONS: Create a VLOOKUP formula to display Status in cell D3 Using data from "Worksheet 2", create a formula in cell D3 that will display the Won/Lost Status according to the Bid Amount in cell B3. 4INSTRUCTIONS: Conditional Formatting Use conditional formatting to fill the row with "Lost" status, in gray. Formula = Apply to range columns B3 to D9
Sagot :
Your presence in our community is highly appreciated. Keep sharing your insights and solutions. Together, we can build a rich and valuable knowledge resource for everyone. Your questions find answers at IDNLearn.com. Thanks for visiting, and come back for more accurate and reliable solutions.
