Home
Connect Your iPad to a Projector
/ 0
There are a number of ways to connect an iPad to a projector to display photos, video or give a presentation.
Autofit Excel Column Widths using the Mouse
/ 0
Excel provides a neat way to autofit the width of a column using either a mouse double-click or using the built in menus. In this post I will show you how to use the mouse to automatically resize the width of a column so that the contents of the column can be seen in full.
Colored Shapes with Conditional Formatting
/ 1
You can use Excel conditional formatting and the Wingding font to create colored shapes in a cell. In the example at right, colored shapes will appear in cells C2:C7, depending on the value in the adjacent cell in column B. If the value is less than 10, a red circle will appear, if the value is greater than 30, a green square will appear. Otherwise, a yellow diamond will appear.
Conditional Formatting Basics
/ 0
Conditional formatting allows users to create rules for selected cells that controls the way Excel formats those cells based on the contents of the cells and the criteria established by the user. If the rules (conditions) that are specified are met, then the formatting is applied. For example, a user could use conditional formatting to change the font color of all cells with negative values or change background color of cells with duplicate values.