VBA HELP (I already have done the fill color to yellow I can not figure out the next steps
Using VBA, in column D of the worksheet, enter “Invalid Part Number” for a row that does not have a valid part number (one that begins with a letter). Change the Fill color to yellow.
Next, part numbers that are even numbers are ones the firm produces itself, while ones that are odd numbers they purchase from an external source. Again, using VBA, for the valid part numbers display in column D, “Ours” for the ones we produce and “Purchase” for the ones we get from external sources.
Solved by B. J. in 15 mins