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