Carpe diem: Excel - Conditional Formatting

This is taken from the article I wrote "Spreadsheets Can Be Fun!".  I wanted it in PAGES too so all my excel tutorials will be collected in one area of my cubit.

This is not a tutorial about how to use Excel but rather a feature you may not have discovered.  I use this as a time saver and to me is fun (my life is not very exciting). 

This feature is “Conditional Formatting” which is used to make things happen that are not standard in cells.  An example of this would be to make a cell turn a certain color when a number or range of numbers is typed in the cell.  Teachers can use this to make a cell turn blue when 90-100 is entered, 80-89 would turn green, 70-79 yellow…..you get the idea.  This gives a quick visual of how students are doing. 

This is only an example as there are many more uses for the "Conditional Formatting" feature.

Here is how to do that.
Highlight the cells you want to format:

2010-07-09/weeds/f23eb0

 

Click on Home Tab and then Conditional Formatting,
Highlight Cell Rules, Between:

(Note- there are many other choices for formatting,
this is just one example)

2010-07-09/weeds/7e3586

When the formatting box opens, add the first number 90, then second number 100, click on custom format, choose your color, then OK.  Do this for as many conditions you want.

2010-07-09/weeds/8e9787

This is the finished worksheet.  If you go back and change a number in a cell, the color will automatically change to match your format.  Try it! 

I used light colors to make it easier to see in this example.

2010-07-09/weeds/776164

This feature is not limited to using numbers.  Words can also be used so when you type the word green, the cell (or just the text) will turn green.  When making a spreadsheet, format the blank cells before you enter data and the cells will follow the format when you type in them.

There are many more fun and useful things to do within the Excel Program.  If there seems to be an interest in these features, there will be another “how to” article coming soon.  Excel has many uses not related to business or work.  It is a good way to keep up with information at home and with hobbies.

I have used it to organize my plants listing when purchased, common name, Latin name, bloom color, etc.  Let us know how you use this program.

I just added an Excel question and answer forum and my first tutorial on Excel Basics in the PAGES section.  So, if you are interested in learning more or helping others learn this program, visit our Cubit!
Carpe diem

« Return to Carpe diem

« Return to the Pages table of contents.

Carpe diem

This is a meeting place for people all over the world to discuss and share information about all areas of this ever shrinking globe. NEW!! I have added a forum for discussions about using Excel and tutorials in the PAGES section.

» Home
» Forums
» Articles
» Pages
» Links

Cubit owner: weeds

Admin team:

» Contact the admins













Want to browse around and see what other Cubits are about? Try the Cubit Finder