Hi Paul, I am trying to add more to this sheet... What I want to do is Color specific Required Columns Yellow on the MDS Equipment Detail sheet if they are missing info if the first Cell B7 has data entered. I want to keep it in line with the code you already helped me with. Using the specific headers for the required cells. Mfg, Model Name, Model, Serial Number, Equipment ID etc.. I will add more as I want to make them required. I also want to Color the cells in the following Columns on the MDS Equipment Detail sheet Pink if they are Duplicates: Serial Number, Equipment ID, IP Address, Host Name, Oracle Config SN and MAC Address.
Reply With Quote