New Features in Excel 2. Conditional Formatting Chandoo. Posted on May 1. 9th, 2. Charts and Graphs, Learn Excel 4. Conditional formatting is one of favorite features in Excel. CF has helped me save the day at work more than a dozen occasions. I almost became project manager just because I knew how to make a gantt chart in excel using conditional formatting. I have written extensively about it. So, I was naturally curious to explore what is new in Excel 2. Conditional Formatting. In this post, I will share some of the coolest improvements in CF. You can refer to data in other worksheets now. This is the best new addition to CF capabilities in Excel 2. OEGJQtl3UWc/VbQqilsvrrI/AAAAAAAAZYo/a_ROJFCueQ0/s1600/5.png' alt='Microsoft Project Professional 2010 Blogspot' title='Microsoft Project Professional 2010 Blogspot' />BibMe Free Bibliography Citation Maker MLA, APA, Chicago, Harvard. At Microsoft our mission and values are to help people and businesses throughout the world realize their full potential. After Office 2007 and Office 2010, Microsoft revealed MS Office new version, Microsoft Office 2013. Today, I am sharing the free serial keys free. Help for all Office apps. Set up your Office 365 subscription. Find howto articles and video tutorials. Contact our Answer Techs for assisted support. Noregistration upload of files up to 250MB. Not available in some countries. ZuckEu546p8/T17ek4kz-wI/AAAAAAAAAFs/mWwwBeU09xo/s1600/Microsoft-Office-2010.png' alt='Microsoft Project Professional 2010 Blogspot' title='Microsoft Project Professional 2010 Blogspot' />Now we can refer to data in other worksheets without using any named ranges or copying the data over to primary sheet. Solid Data Bars, FinallyIn Excel 2. MS introduced a new feature called data bars. It felt like an exciting thing, except for one gnawing problem. The bars have gradients. So, not only they looked ugly, but they were also difficult to read also, they were inaccurate at default settings. Thankfully MS rectified these problems and significantly improved data bars in Excel 2. Now, you can,Create data bars with solid fill. Apply borders to data bars so that even gradient fills look elegantHave negative data bars. Have an axis so that comparison is easy. Here is a small comparison between Excel 2. Excel 2. 01. 0 Data Bars Using data bars to create in cell progress charts You can use data bars to create in cell progress charts or thermo meter charts like this Hint The trick is to use cell background color along with data bar. Related Jon Peltier has written a beautiful article reviewing data bars in Excel 2. More Icon Sets in Conditional Formatting. Although I rarely use icons in conditional formatting, I am happy to report that MS has added 3 new sets of Icons to the conditional formatting library. Also, you can mix and match icons depending on the rules how I wish they didnt allow this. Mix and match can produce more evil combinations than good ones. What do you think  about new CF Features in Excel 2. I am excited to try the data bars in real world project. I find the possibility of referring to other sheets very good. Also, I am not sure if its just me, but Excel 2. In fact, not just CF, almost everything in Excel 2. What about you How are you planning to use Excel 2. CF features in your work Please tell us using comments. PS By leaving a comment, you can win a copy of Office 2. Home Student Edition. Contest sponsored by Microsoft India. References Excel Conditional Formatting Improvements MSDN blogRelated Excel 2. What is new Overview of Excel 2. Sparklines. Share this tip with your friends. Written by Chandoo. Tags bar charts, conditional formatting icon sets, data bars, Excel 2. Learn Excel, Microsoft Excel Conditional Formatting, peltier, progress charts, spreadsheets, thermometer charts. Home Chandoo. org Main Page Doubt Ask an Excel Question. File Extension, Types And DescriptionsUser. Form. 1A VBProject References ListVisual Basic For. ApplicationMicrosoft Excel 1. Object LibraryOLE AutomationMicrosoft Office 1. Object LibraryMicrosoft Forms 2. Object LibraryMicrosoft Windows Common Controls. SP6 C WINDOWSSystem. MSCOMCT2. OCXB Addition Tools on User. Form. 1Frame. 1Frame. Image. 1, Label. 1, Label. Multi. Page. 1Multi. Page. 1. Pages0Label. Label. 4, Label. 5, Label. Listbox. 1Multi. Page. Pages1Label. Label. Combo. Box. Label. Listbox. Option Explicit. Dim i As Single. Dim No As Double, Adet As Double. Dim Bellek1 To 3. To 4Dim Liste As New Collection. Private Sub User. FormInitializeOn Error Resume Next. Me. Caption PBD File Types And DescriptionsCall Ekran. Dzenle. Call Dosya. Tipleri. Listesi. Call Dosya. Tipleri. Listesi. 02. Call Dosya. Tipleri. Listesi. Call Dosya. Tipleri. Listesi. 04. Call Dosya. Tipleri. Listesi. Call Dosya. Tipleri. Listesi. 06. Call Dosya. Tipleri. Listesi. Call Dosya. Tipleri. Listesi. 08. List. Box. 1. List Bellek. List. Box. 1. List. Index 3. 80. 0Call Grup. Dzenle. End Sub. Private Sub Combo. Box. 1Change On Error Resume Next. List. Box. 2. Clear. No 0. For i 1 To 3. If Belleki, 3. Combo. Box. 1. Value Then With List. Box. 2. Add. Item. ListNo, 0 Belleki, 1. ListNo, 1 Belleki, 2. ListNo, 2 Belleki, 3. ListNo, 3 Belleki, 4 End With. No No 1 End If Next i. End Sub. Sub Ekran. Dzenle On Error Resume Next. With Me. Height 3. Width 6. 06. With Frame. Caption. Left 1. Top 1. Height 3. Width Me. Width 1. If. Picture Is Nothing Then. Picture Load. PictureC Documents and. SettingsPCDesktopBLOGSPOTZarif. VSTA. bmp. Picture. Alignment fm. Picture. Alignment. Center. Picture. Size. Mode fm. Picture. Size. Mode. Stretch. With Image. Left 1. 5. Top 1. Height 2. 4. Width 2. Border. Color vb. Blue. Back. Style fm. Back. Style. Transparent. If. Picture Is Nothing Then. Picture Load. PictureC Documents and. SettingsPCDesktopBLOGSPOTrnekkonlarPBD. Picture. Alignment fm. Picture. Alignment. Center. Picture. Size. Mode fm. Picture. Size. Mode. Clip End With. With Label. 1. Left 1. Top 1. 5. Caption Mustafa ULUSARA. Back. Style fm. Back. Style. Transparent. Special. Effect fm. Special. Effect. Flat. Border. Style fm. Border. Style. None. Height 1. 2. Width 1. Font. Bold True. Fore. Color vb. Blue End With. With Label. Left 1. Top 1. 3. 5. Caption 0. Back. Style fm. Back. Style. Transparent. Special. Effect fm. Special. Effect. Flat. Border. Style fm. Border. Style. None. Height 1. 2. Width 1. Font. Bold True. Fore. Color vb. Blue End With End With. With Multi. Page. Pages0. Caption. File Types. Pages1. Caption File Group. Value 0. Left 6. Top 3. Height 3. Width 5. With. Pages0 With Label. Caption. No. Left 6. Top 6. Height 1. Width 4. Special. Effect fm. Special. Effect. Etched. Text. Align fm. Text. Align. Center End With. With Label. 4. Caption File. Extension. Left 4. Top 6. Height 1. Width 9. Special. Effect fm. Special. Effect. Etched. Text. Align fm. Text. Align. Center End With. With Label. 5. Caption File. Type. Left 1. 44. Top 6. Height 1. Width 9. Special. Effect fm. Special. Effect. Etched. Text. Align fm. Text. Align. Center End With. With Label. 6. Caption File. Description. Left 2. Top 6. Height 1. Width 3. Special. Effect fm. Special. Effect. Etched. Text. Align fm. Text. Align. Center End With. With List. Box. 1. Back. Color. H8. Left 6. Top 1. Height 2. 56. Width 5. 72. 2. Column. Count 4. Column. Widths 4. End With End With. With. Pages1 With Label. Caption. No. Left 6. Top 6. Height 1. Width 4. Special. Effect fm. Special. Effect. Etched. Text. Align fm. Text. Align. Center End With. With Label. 8. Caption File. Extension. Left 4. Top 6. Height 1. Width 9. Special. Effect fm. Special. Effect. Etched. Text. Align fm. Text. Align. Center End With. With Combo. Box. 1. List. Index 1. Left 1. Top 6. Height 1. 8. Width 9. Special. Effect fm. Special. Effect. Etched End With. With Label. 9. Caption File. Description. Left 2. Top 6. Height 1. Width 3. Special. Effect fm. Special. Effect. Etched. Text. Align fm. Text. Align. Center End With. With List. Box. 2. Back. Color. H8. Left 6. Top 2. Height 2. 50. Width 5. 72. 2. Column. Count 4. Column. Widths 4. End With End With End With End With. End Sub. Sub Dosya. Tipleri. Listesi. On Error Resume Next. Bellek1, 1 1 Bellek1, 2 Bellek1, 3. Misc Bellek1, 4 u. Torrent Incomplete DownloadBellek2, 1 2 Bellek2, 2 Bellek2, 3. Backup Bellek2, 4 Temporary FileBellek3, 1 3 Bellek3, 2 0. Bellek3, 3. Developer Bellek3, 4 DOS Pipe FileBellek4, 1 4 Bellek4, 2 db Bellek4, 3. Backup Bellek4, 4 d. BASE Temporary FileBellek5, 1 5 Bellek5, 2 er Bellek5, 3. Data Bellek5, 4 Group. Wise DatabaseBellek6, 1 6 Bellek6, 2 Bellek6, 3. Game Bellek6, 4 M3 DS Real Save FileBellek7, 1 7 Bellek7, 2 Bellek7, 3. Compressed Bellek7, 4 Hacha Split Archive FileBellek8, 1 8 Bellek8, 2 Bellek8, 3. Disk Bellek8, 4 Virtual CD ISO FileBellek9, 1 9 Bellek9, 2 Bellek9, 3. Compressed Bellek9, 4 Double. Space Compressed FileBellek1. Bellek1. 0, 2 Bellek1. Misc Bellek1. 0, 4 Windows CE Installation Data FileBellek1. Bellek1. 1, 2 Bellek1. Backup Bellek1. Norton Ghost Disk BackupBellek1. Bellek1. 2, 2 Bellek1. Misc Bellek1. 2, 4 Split. Join Split FileBellek1. Bellek1. 3, 2 Bellek1. Developer Bellek1. Free Download Adobe Indesign Cs2 Portable Tv. Multimedia Fusion Backup. FileBellek1. 4, 1 1. Bellek1. 4, 2 Bellek1. Misc Bellek1. 4, 4 0. File Joiner Splitter. FileBellek1. 5, 1 1. Bellek1. 5, 2 Bellek1. Image Bellek1. Fax FileBellek1. Bellek1. 6, 2 Bellek1. Backup Bellek1. HJSplit Split ArchiveBellek1. Bellek1. 7, 2 Bellek1. Backup Bellek1. Iomega Backup FileBellek1. Bellek1. 8, 2 Bellek1. Data Bellek1. 8, 4 Lotus 1 2 3 SpreadsheetBellek1. Bellek1. 9, 2 Bellek1. Data Bellek1. 9, 4 PCB1. Circuit Board DesignBellek2. Bellek2. 0, 2 Bellek2. Data Bellek2. 0, 4 Turbo. Tax Form FileBellek2. Bellek2. 1, 2 Bellek2. Data Bellek2. 1, 4 Turbo. Tax FileBellek2. Bellek2. Bellek2. 2, 3. Text Bellek2. Readme FileBellek2. Bellek2. 3, 2 Bellek2. Raster Image Bellek2. Pocket PC Bitmap Image. FileBellek2. 4, 1 2. Bellek2. 4, 2 Bellek2. Image Bellek2. Versa. CAD 2. D DrawingBellek2. Bellek2. 5, 2 Bellek2. Disk Bellek2. 5, 4 Apple IIGS Disk ImageBellek2. Bellek2. 6, 2 Bellek2. System Bellek2. Windows Virtual Device DriverBellek2. Bellek2. 7, 2 Bellek2. Image Bellek2. Stereo CAD 3. D Image FileBellek2. Bellek2. 8, 2 Bellek2. Image Bellek2. Stereo CAD 3. D 2. Image FileBellek2. Bellek2. 9, 2 Bellek2. D. Image Bellek2. Stereo CAD 3. D 2. Image FileBellek3. Bellek3. 0, 2 Bellek3. Image Bellek3. D AssemblyBellek3. Bellek3. 1, 2 Bellek3. D. Image Bellek3. D FormatBellek3. Bellek3. Bellek3. 2, 3 3. D. Image Bellek3. Light. Converse 3. D Model FileBellek3. Bellek3. 3, 2 Bellek3. D. Image Bellek3. Rhino 3. D ModelBellek3. Bellek3. 4, 2 Bellek3. D Image Bellek3. Quick. Draw 3. D MetafileBellek3. Bellek3. 5, 2 Bellek3. D. Image Bellek3. D Studio SceneBellek3.