Progress bars are pretty much ubiquitous these days; we’ve even seen them on some water coolers. A progress bar provides instant feedback on a given process, so why not bring some of that graphical pizzazz into your spreadsheet, using Excel’s Conditional Formatting feature?
Progress Bars in Excel 2010
“Bar-type” conditional formatting has been around since Excel 2007. But Excel 2007 would only make bars with a gradient – the bar would get paler and paler towards the end, so even at 100% it wouldn’t really look like 100%. Excel 2010 addresses this by adding Solid Fill bars that maintain one color all throughout. These are ideal for creating progress bars.
Creating The Bar
The first thing you have to do is enter a numeric value into the cell you’d like to format. You can either enter the value directly or use a formula. In our case I’ll just type it in.
Note how I made the column wider; you don’t necessarily have to do this, but it does help make the bar look more like a “bar” (and not just a colored cell).
Now click Conditional Formatting, select Data Bars and click More Rules.
In the New Formatting Rule dialog check the box that says Show Bar Only (so the number doesn’t appear in the cell). Under Minimum and Maximum, select Type as Number. Then, set the Value to the minimum (beginning) value of your scale and maximum (the top of your bar, the end of the process). We’ll just go for 0 and 100, but you could set this to anything that works for you.
Now let’s configure the Bar Appearance. Make sure the Fill is Solid Fill and select the color you’d like to use. When you’re done, the dialog should look similar to this:
Now click OK, and you’re done! At this point you should have a beautiful, crisp progress bar adorning your spreadsheet.
Malware has become increasingly sophisticated and widespread; it’s more important than ever to have a robust toolkit for dealing with it. This week we want to hear about your favorite tips and tricks for dealing with malware infestations.
Steve Jobs announced the iPad 2 moments ago which will touch off a flurry of new purchases, upgrades, and general Apple-centric muttering and fist shaking. Will you be buying an iPad 2?
Google has dusted off the Picasa Web interface and updated it with an emphasis on highlighting your photos and the photos of those you’re interested in.
If you frequently hit up YouTube to get your music fix, Uwall.tv is a video playlist service that turns YouTube into your personal music video jukebox.
If you’re an Android fan and looking to score an Android 3.0 tablet, you can enter to win a Xoom tablet courtesy of the Complete Android Guide.
Brightness and Contrast tools are for beginners! Ever wondered what graphics programs offer advanced users to ensure their photographs have a great value range? Read on to learn about Levels, Curves, and Histograms in three major programs.
If the Gmail scare earlier this week has you thinking about backing up your Gmail or other web-based email account, we’re here to help. Read on to learn how to backup your web-based email using open source email application Thunderbird.
Would you prefer a much quicker way to access the options for your favorite extensions in Firefox? Now you can skip opening the Add-ons Manager Tab and access them directly by menu using the Extension Options Menu add-on for Firefox.
Don’t Sleep is an ultra lightweight and portable application that fills a niche need perfect: sometimes you need to temporarily keep your Windows machine from shutting down or power saving without making any permanent ...
DropSpace is a free Android application that fixes the primary issue that plagues the official Dropbox app for Android–the lack of true file synchronization. Grab a copy of DropSpace and start enjoying true file syncing on the go.