I just got a call from a friend of mine. He needed to edit a spreadsheet and round a bunch of formulas. Since the rounding is important for the calculations, a simple cell-formatting wouldn't do.
Excel's worksheet function =ROUND() can be used to round the numbers. However editing a lot of cells by hand (especially with ...
It has been on of those 'spam-periods' again. My inbox this morning: Fortunately most spam is detected and all virussus are removed, but still a lot of rubbish comes through the filters.
I use Outlook 2003 and I have also tried Thunderbird (Mozilla) but still too much spam comes through in both mail clients. My list of ...
Jeremy (US) asked me a question about coloring based on a cells value: First your product ASAP Utilities is great and has been a life saver. One feature that would be outstanding is a conditional row color based on a cell value.
For instance there are numerous times I have to color a row because the value ...
I'm working on an ASAP Utilities User Guide. When describing some of the worksheet function that use the colorindex property, I needed a good example of all available colors.
So I wrote a quick macro to create a colorindex-table but enhanced it to show the colors in the same order as it is shown in ...
Yesterday I got a question about the unit system in Excel. Andy from down under wrote: I am not a huge user of all the complex stuff that excel does but your ASAP has made my work easier.
Simple thing like changing case when I've left the caps lock on!!
I do have a question for you. ...
(Update October 18, 2007: If you want an easier way to do this, see this post: Video: How to sort by color in Excel with ASAP Utilities) In Excel you can only sort by value, not by formatting such as cell colors. With ASAP Utilities you can! Here's a short example how to do sort by ...