This week, there were a couple of Excel conditional formatting questions in the blog comments. Ron asked about changing the font colour for the highest, second highest and lowest values. Guido wants to highlight values that aren't multiples of another cell's value.
I'll answer the questions here, so they're easier to find. Maybe you've encountered [...]

August seems to be a very popular birthday month among my Excel friends. I won't mention any names here, because most of them are quite elderly, and the shock might upset them. Anyway, to all of them, and you, if you're celebrating this month -- happy birthday!
The Birthday List
If you're in charge of an [...]

If you've used Excel for a while, you have lots of skills that you might assume everyone else shares. However, based on the Excel questions that I see online, those assumptions are very optimistic! For example, I recently saw this plea on Twitter:
Can anyone help pls? can't work out how to add a LOT of [...]

If you sell products in several countries, you might want to show the prices in different currencies. With the conditional formatting options in Excel 2010, you can change the number format, to show a specific currency for the country that's selected.
Note: Conditional Formatting for numbers was available in Excel 2007, but didn't work correctly. (Thanks, [...]

In a workbook, you might have some sheets that everyone uses, and other sheets that only one or two people need to use, for Admin functions.
For example, the workbook shown below has a data entry sheet for orders, and two Admin sheets -- one for lists and one for workbook options.

To make it obvious which [...]

I saw this on Twitter yesterday: Wanted "Break Apart all merged cells in entire spreadsheet" button
If you've done much work in Excel, you've probably encountered problems that are the result of merged cells on a worksheet. Merging cells can seem like a good idea at the time, but can interfere with sorting and filtering, and [...]

To highlight specific cells on an Excel worksheet, you can use conditional formatting. In the example shown below, orders with a quantity greater than 50 are highlighted with green fill colour.

This was the result of simple conditional formatting, based on the cell value.

Sometimes though, the conditional formatting can be distracting, and there's no built in [...]

In the last blog post, you saw how to turn off buttons and drop downs in an Excel 2007 pivot table. In the comments, Jon Peltier suggested a simple Copy and Paste Values instead, but that doesn't paste the pivot table style formatting.
Then, John Walkenbach pointed us to one of his articles, which describes [...]

Every now and then I get a workbook from a client with numbers in Accounting format. If all the numbers are the same length, the currency symbols line up nicely. However, if the numbers are different lengths, some of the symbols are a bit off.
For example, in the screen shot below, the $ sign in [...]

I'd need wider columns to hold my golf scores, but this Excel template for golf scores might help you keep track of your annual progress.
 
There's also an annual summary sheet, that calculates your average score and best score for the year.

Conditional Formatting for Scores
The golf scores template uses conditional formatting to highlight the [...]