04 December 2007

Excel Formatting

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.