Excel - How do I conditionally insert text into a cell on Excel 2007?

Asked By RobertTF on 07-Aug-08 03:20 PM
I am using Excel 2007. I am trying to insert text into a cell based on the
value of the cell next to it. Example If NO is typed into cell B1, I want to
insert EXPLAIN in cell B1

Peo Sjoblom replied on 07-Aug-08 03:58 PM
I assume you meant C1 or else you would need an event macro


since you did not mention what you want if it is not "No" I made it blank



Peo Sjoblom