by Ilker | May 17, 2018 | Excel Tips & Tricks
To highlight a row may be tricky because there is no built-in option to in Excel’s Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on row numbers Open...
by Ilker | Apr 27, 2018 | Excel Tips & Tricks
It’s often a good idea to highlight duplicate values in a data set to help easily identify the outliers. Here, you can find out how you can do this dynamically using Excel formulas. Syntax =COUNTIF(absolute data range reference, relative cell reference) Steps Begin by...
by Ilker | Apr 23, 2018 | Excel Tips & Tricks
It’s often a good idea to highlight the top values in a data set to help easily identify the outliers. Here, you can find out how you can do this dynamically using Excel formulas. Syntax =relative cell reference >= LARGE(absolute data range reference, top...
by Ilker | Oct 8, 2018 | Excel Macros, Excel Tips & Tricks
Named ranges are very useful when creating Excel models. However, it can get pretty hard to track what named range belongs where as your model grows. Highlighting them on your worksheets can help you identify their properties easily. In this article, we’re going...
by Ilker | Sep 13, 2021 | Excel Tips & Tricks
Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. Download Workbook...
by Ilker | Jun 7, 2021 | Excel Tips & Tricks
Using different coloring makes it easy to highlight differences in data or the layout of your spreadsheets. Excel has support for rows with alternating coloring in tables. What if your table contains similar values in groups, and you want to color the rows based on...
by Ilker | Jan 29, 2019 | Excel Tips & Tricks
Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional formatting...
by Ilker | Oct 9, 2018 | Excel Macros, Excel Tips & Tricks
Finding cells with errors can be tricky, especially in large workbooks. In this article we’re going to show you how to display cell formulas in Excel that contain errors using VBA. How to display cell formulas in Excel that have errors VBA has predefined types...
by Ilker | Sep 6, 2018 | Excel Tips & Tricks
One of the essential tasks when cleaning up a data set is getting rid of duplicate values. In this article, we’re going to show you how to remove duplicates in Excel using the Remove Duplicates feature. To find duplicate values using a formula please see: How...
