Keeping cells with formula and conditional formatting blank until data entered

I have a spreadsheet filled with formulas that depend on a value being entered into A2, A3, A4, etc... So column A starting at A2 is where I will manually input a number and the formulas I have in columns B, C, and D will import information from another sheet based off what is put in column A. In column D the formula I have to import data is =IFERROR(VLOOKUP(A2,Master!C:M,11,0),""). This will import another number. Additionally in column D, I have conditional formatting that will return a red, yellow or green light based off the rule I have in place. Everything works fine, the only problem is that column D has a green light all the way down even without a value being placed in column A. I would like to find out a way to keep the cells in column D blank until a value is entered in column A. Also, if I go back and delete the value in column A, I would like the corresponding cell in column D to go back to blank as well. Is this possible or am I asking too much from Excel? Thank you in advance for your help!

Yeah the only thing is the stop lights are preferred by my boss. Is there anyway to make them not show up until a value is entered in column A?