Tutorial search
Tutorials
Stuff
Affiliates
Photoshop Templates
Featured Photoshop templates - professional ready to use designs for your next project.
View all templates
Conditional color formatting in Excel - Excel tutorial

Conditional color formatting in Excel tutorial description
| Added on | 27.02.2008 |
| Total clicks | 16 |
| Tutorial Rating | 0 |
| Tutorial Difficulty | 0 |
Conditional color formatting in Excel
More cool Excel tutorials:

Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the formatting of text. We can use : bold face, italics, underline, change the color, align (left, right, center), font size, font, etc.

The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number. Very useful for break even analysis. This clip also shows you how to perform a goalseek straight off a graph.

Merging two Excel files using VLOOKUP function is very powerful and convenient for Data Analysis when manual matching of two files is very time consuming because of size of data.

Calculate the interest RATE charged on a constant annuity cash flow.

Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down.




