result of a drop down list changing other cells

[excell beginner]

Hi guys

This is my first post on here so I think I should introduce myself, I am an Excell noob and I cannot stress that enough, I used it a few times in IT in school about ten years ago and nothing since until now, so I need your expert help badly please! I also apologise for how basic my questions probably are.

I have taught myself how to create drop down lists, what i need to know is how do i get the specific answers in the drop down list to affect other cells.

Specifically I have a drop down list with the options 'yes or no' if yes is selected i want text to 'appear' in another cell (the text in the target cell I want to appear is already the result of another separate formula). I am guessing the easiest way to do this is to have this text coloured as white so it is invisible, however if 'yes' is selected in the drop down list it changes colour to black and so appears?-however I have no idea how to make this happen.

I am using Excell 2007. Any help would be greatly appreciated!

[Pete_UK]

You can use an IF function in the target cell, along these lines:

=IF(D1="yes","correct","")

where I have assumed your drop down is in cell D1.

You can also do it using conditional formatting, which is more along the lines of what you describe.

Hope this helps.

Pete

[excell beginner]

Thanks for the reply Pete, that is very helpful and useful to know.

I have tried that formula and it works great on a cell with no formula in and makes the text only appear if yes is selected just as i wanted, theonly problem is the cell I need it to effect already has the formula ="**** Comments due by " & TEXT(MAX(C13), "d mmmm yyyy") & " ****" in it. So i guess i need to somehow combine these two formulas together so that they both work for this cell, any ideas?

[Aardigspook]

Welcome to the forum.

As you guessed, you just need to combine the IF statement with your current formula. If your dropdown is in A13, use this:

Please Login or Register  to view this content.