is it possible to make comment appear faster in excel?

How can make a cell appear based on a result in Excel?

• For example 1 - Do you want to link example to example ? Yes or No answer (drop down) 2- Add link address www.example.com(freeText) If the result of drop down is yes in row 1 then row 2 should appear asking the link address. Please explain in step by step as I am a newbie with excel

• Answer:

  The result from the drop down box will go somewhere - often filling a cell with either "TRUE" or "FALSE". Right click on the drop down and select "Format Control" and then Cell Link to where you want the result to be. Then on the other cell, assuming the result is true or false type in cell A1, put in the formula: =if(a1="TRUE","Add link address www.example.com(freeText)", "") Where you can change the text between " " to be what you want. Leaver all the "'s in