You probably didn't expect to see an Excel tip on this blog but this one is just so useful I had to share it with the whole world (or the two of you who read this blog).
Let's say you have a simple spreadsheet for party invitations like so:
And you would like to conditionally format the person column based on another column.
So let's say if a person is coming to the party their name should be green. All you do is select cells a2:a5 go to conditional formatting in the home ribbon and select new rule, then select use a formula and type in:
Select the color, and this is what you get when you hit ok:
Those of you that are "fluent" in Excel will laugh at me and say duh, oh well.