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.

Conditional Formatting:

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.”

Here is a short tutorial video on how to do this in Excel 2003:


Excel – Conditional Formatting in 2003

Here is a short tutorial video for Excel 2007:


So how would you use this?