Colorcode words/"tags"

[b.carlsson]

Honored excel pros!
Im in the process of setting up a 2010 calendar to keep track of my food, workout and alcohol habits.

Is there a way to create certain tagwords, like "alcohol", an excel imediatly shows it in a specific color/bold font?

Thankfull for answers!

/Björn

[davesexcel]

Check out conditional formatting
http://www.contextures.com/xlCondFormat01.html