INSTRUCTIONS: Insert Data Validation $-$ Dropdown list, in cell B$3-$B$9$

Create a "List of items" referencing the Bid Amount from Worksheet $2.$

INSTRUCTIONS: Create a VLOOKUP formula to display Potential Revenue in cell C$3$

Using data from "Worksheet $2",$ create a formula in cell C$3$ that will display the Potential Revenue

according to the Bid Amount in cell B$3.$

INSTRUCTIONS: Create a VLOOKUP formula to display Status in cell D$3$

Using data from "Worksheet $2",$ create a formula in cell D$3$ that will display the Won$/$Lost Status

according to the Bid Amount in cell B$3.$

INSTRUCTIONS: Conditional Formatting

Use conditional formatting to fill the row with "Lost" status, in gray.

Formula $=$ Apply to range columns B$3$ to D$9$