Learn how to change the font color of cells in Excel based on their values, whether it's positive/negative numbers, specific values, or text, using Conditional Formatting and Custom Number Formatting.| Spreadsheet Planet
Learn how to highlight every other row in Excel using Conditional Formatting, Banded Rows Table Styles, and VBA. Make your data more readable and easier on the eyes with these simple techniques.| Spreadsheet Planet
Learn how to select multiple rows in Excel, whether they are contiguous or non-contiguous, using simple and quick methods.| Spreadsheet Planet
Learn how to filter data in Excel based on cell color using different methods such as the filter option, right-click menu, custom sort, and VBA script.| Spreadsheet Planet
In this tutorial, I will show you the step-by-step process to highlight a cell if the a value exists in another column in the worksheet in Excel.| Spreadsheet Planet
Learn how to use conditional formatting with OR criteria in Excel to highlight data that meets at least one condition.| Spreadsheet Planet
Learn how to filter data dynamically as you type in Excel using the FILTER function in Office 365 ((No VBA needed)) or using a simple VBA code| Spreadsheet Planet
Learn how to quickly delete hidden rows and columns in Excel using the Inspect Document feature or VBA code (without manually doing it)| Spreadsheet Planet
Learn how to change cell color based on the value of another cell in Excel using a formula in Conditional Formatting.| Spreadsheet Planet
Learn how to move rows to another sheet in Excel based on a specific cell value using filters trick and simple VBA macro codes.| Spreadsheet Planet
Learn different methods to check if a value is in a list in Excel, including using functions like COUNTIF, OR, and MATCH. Find out how to validate data in large datasets.| Spreadsheet Planet
Learn how to select rows with specific text in Excel using a simple VBA code or a simple Data Filters trick.| Spreadsheet Planet
Learn five methods to copy row height in Excel, including using the ribbon, format painter, paste special, Kutools add-in, and keyboard shortcuts.| Spreadsheet Planet
Learn to paste data into filtered columns without affecting hidden cells in Excel (using a simple formula trick and some simple VBA code)| Spreadsheet Planet
Learn how to hide columns in Excel based on cell values using VBA macros. This tutorial provides step-by-step instructions for both real-time and macro-executed hiding.| Spreadsheet Planet
Learn how to compare two cells in Excel using formulas for an exact or partial match, including case sensitivity. Also convers how to compare numeric cells| Spreadsheet Planet