SysChat is a free online computer support community. Ask questions, share resources, contribute knowledge and discuss technology. Join our growing community to access all features. Register Now!

SysChat » Tips 'n' Tricks » Microsoft Office » How to Create Progress Bars in Excel With Conditional Formatting

Microsoft Office

tips on microsoft office suite

Comment
 
LinkBack Tip Tools
 

How to Create Progress Bars in Excel With Conditional Formatting

By dothy1005
03-15-2011
These days, we see progress bars everywhere; we see them online on our phones, androids, mp3 players and many other devices. A progress bar is a graphical representation of an ongoing process that gives us an idea on how long we still have to wait for it to complete.

Now you can add these colorful bars on your spreadsheets through Microsoft Excel 2010’s Conditional formatting feature.

To create a progress bar, you need to type a numeric value into the cell that you need to format. You can either type a value or use a formula. Next, we suggest that you resize it to a wider column to make it look more like a bar.

Then, click on Conditional Formatting, choose Data Bars and select More Rules.
Locate the New Formatting Rule and check the box that says “Show Bar Only”. Doing this will hide the value/formula you entered and it will not appear in the cell.

Next, go to Minimum and Maximum and choose Type as Number. Then, set the minimum and maximum value of your scale. Then customize the bar appearance. Remember that you need to make sure that you have selected Solid Fill and then choose the color you prefer to use. Click OK and that’s it!
Comment





Similar Threads
Tip Tip Starter Category Tips Last Post
Create a Hyperlink to a Different Document in an Excel Worksheet dothy1005 Microsoft Office 0 03-18-2011 02:39 AM
Resolving Excel Error Message “Excel.EXE is not in a valid Win32 application.” macsmith85 Articles 0 01-05-2010 12:58 AM
How to Create A Microsoft Excel Macro in 7 Steps dwarkarao Microsoft Office 0 12-03-2009 08:20 AM
Formatting Disks in Windows Vista supahman1000 Windows 0 11-25-2007 11:06 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are on



» Ads



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54