In the worksheet, the user will enter a resistance value as the first two digits and a multiplier, both selected using a drop$-$down menu created through data validation. The resistance should be calculated as the first two digits times the multiplier.

The worksheet should automatically determine the First Digit and the Second Digit of the value entered in cell E$7,$ using the built$-$in functions LEFT and RIGHT. The number of zeros should be determined using the lookup function.

Finally, the worksheet should determine the corresponding resistance band color using the Color Code table. The cells should automatically change to the correct color when the digits or multiplier are changed using conditional formatting.

For example, a resistance of $4700$ ohms $[\backslash$Omega $]$ has first digit $4($yellow$),$ second digit $7($violet$),$ and two zeros following $($red$).$ A resistance of $56$ ohms would be $5($green$),6($blue$),$ and $0$ zeros $($black$)$; $1,000,000$ ohms is $1($brown$),0($black$),$ and $5$ zeros $($green$).$ Note that if the second digit is zero, it does not count in the multiplier value.

Make sure and have all of your answer in Excel.