How to find duplicates and unique values in Excel with Conditional FormattingYou created an Excel spreadsheet one day, updated it the next week, maybe someone else added a bit more information and it snowballs from there? Or maybe your problem is just the opposite, finding that one unique value in the ever growing spreadsheet; Conditional Formatting solves both of your problems... Continue reading
Excel: Conditional formatting for cells (and staff members) based on their valuesConditional formatting gives you the opportunity to apply a rule to a cell (one or more) in your Excel spreadsheet and from there you control the cell color, content or borders. Once your rule has been met, the formatting will be applied - and in our case that formatting will and did help us learn about our employees... Continue reading
Conditional formatting in Excel PivotTablesWith the release of Excel 2007, Microsoft provided some additional conditional formatting options such as data bars and icon sets which makes it easy to apply formats to cells to show visually the relative values in those cells. Microsoft also changed how conditional formatting is applied to PivotTables which gives you a greater flexibility when using conditional formats with data summarized in a PivotTable... Continue reading
Click Like and get 15% discount on all our products right now!
Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
