Conditional Formatting Tutorial – Excel 2007 & 2010

Written by | Published September 27, 2011

Conditional Formatting is the practice of formatting cells in Excel spreadsheets to change cell appearance depending on certain conditions.

It can be extremely useful for immediately highlighting certain parts of a spreadsheet so that your attention is drawn to them – for example when a value goes over a certain threshold, or a date passes its deadline.

In this tutorial we’ll show you how to use conditional formatting to change the colour of cells depending on a percentage.

Why not check out our Top 10 Excel Time Saving Formulas for more helpful tips. 

Conditional Formatting Tutorial – Colour Coded Data

Here’s our example data. We’ve used the 2011 market share figures for smart phone operating systems worldwide.

Excel 2007 Conditional Formatting Tutorial 1

 

Read the rest of “Conditional Formatting Tutorial – Excel 2007 & 2010″

Posted in Blog Posts, Excel Tips, Excel Training, How To | Tagged , , , , , , , , , , , , , , , , , , | No comments yet

How to Embed Excel Tables into Word

Written by | Published February 16, 2011

To start of with you may be asking yourself; why bother adding Excel tables to Word when you can just as easily make your own tables in Word? But if the tables are already created in Excel, it’s easy and simple, just copy and paste the excel table into your Word document.

One problem with doing this is once you have pasted the Excel table into Word, any changes you make in Excel won’t change the Word version. You have to embed the table into Word for you to be able to freely changed both versions.

To do this simply highlight the Excel data you want, copy it, back to the Word document and go to Paste > Paste Special > Paste Link as: Microsoft Excel Worksheet Object. You will now have an embedded table in your Word document which will change as you make any changes in the original Excel document.

Posted in Blog Posts, Excel Tips, How To | Tagged , , , , , | No comments yet