Friday, April 17, 2009

Excel 2007: Eye Candy Check List in Excel, otherwise called “Conditional Formatting”

As a System Admin in IT, Many times I have to make a list in Excel to state status of, say, Servers. I am sure you have some list you have to manager in Excel. Here is the cool way of managing the check list. This is tested in Excel 2007 and I am not sure about the lower versions of Office.

The End result looks like this:

image

Like the idea.smile_whatchutalkingabout  Read ahead for “How to” help.

1. Make a list like above and Select the Status column with header like below picture.

image

2. Now click Conditional Formatting in Home tab and select Icon Sets. Select the ICON that suits your needs. For this document I chose the Tick mark, X icon and ! icon.

image

3.  Leave the Status column selected, click on Conditional Formatting again and Select Manage Rules..

image

4. On Conditional Formatting Rules Manager click on Edit Rule…

image

5. Select Show Icon Only check box on the bottom and click OK. (Note the ICON/Value rule)

image

6. On the Status column cells, enter 1 for tick mark, 0 for X mark and –1 for ! mark.

image

Show your Excel spreadsheet others and show them how to do it.  Look Good!!! smile_shades

2 comments:

Anonymous said...

Good Tutorial..Useful to me...Thanks

K.L. said...

Awesome! So easy. Thanks! :)