One thing I learned at TCEA was how to use conditional formatting in Excel. This is probably something everyone else knows how to do, but I had always wondered how this was done, but had never asked. Since this is new to me, I thought I would share.
I always wondered how people made excel sheets that seemed interactive. It comes down to formatting.
If you type in a question: What is the capital of Texas?
In the cell you want an answer for, you tell it – “If the text types in = Austin, turn the cell green. If the text typed in does not = Austin then turn the cell red.”