Adding comments to your worksheet allows you to share your thoughts with other users, or to serve as a reminder for yourself. It's also useful to be able to add comments to a formula, so that you can let other users of your workbook know if you've made a change to the formula, let them know what the result of the formula represents, or share other information about the … [Read more...]
Using a For Loop
"For" loop is used in a macro whenever you have an action that needs to be performed a set number of times. For example, if you want to change the fill color of the first 20 cells in a list, you could have the macro select the range and simply fill as desired. But what if you wanted to only fill the cells if they were blank, for example? Telling the macro to select the whole … [Read more...]
Twitter 140 Character Tool
Just to have a little fun with the new Twitter account, I thought I'd put together a little Excel tool to make fitting into the 140 character limit a little easier. Simply type what you want to say, and if it exceeds the 140 character limit, it will append "..." to the end, so that the last "." will be the 140th character. That way you'll know how your post will look before … [Read more...]
Highlight Alternating Rows With Conditional Formatting
You can apply conditional formatting to your sheet that will allow you to format every other row however you specify. Select the area where you want to highlight alternating rows. Go to the Format menu and select Conditional Formatting. For Condition 1, select "Formula Is", and type in "=MOD(ROW(),2)=0" if you want to highlight every even row, or type … [Read more...]
Count Colored Cells in a List in Excel 2007
If you have a list with cells of all different colors, you can apply a filter to those cells to have Excel filter them by color, and then apply a formula to count how many of those cells are visible. First, select your list. Right click and choose Filter | Filter by Selected Cells Color. You can then select the filter drop down in your list's first cell and choose which … [Read more...]