Here we have small video that how you may highlight a row based on different cell values. This will help you to understand how you can use excel formulas in conditional formatting to format the cells. Subscribe us for more updates. Happy Learning 🙂
Few Excel Tips 1. CHANGE DIRECTION WHEN YOU PRESS ENTER Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very…
Use Excel’s DATE function when you need to take three separate values and combine them to form a date.
What is Strikethrough in Excel? Strikethrough in Excel is a feature that lets you draw a line through text. It’s like crossing something out, usually to show that it’s no longer needed or has been…
Excel has built-in options to make graphs, it doesn’t have a heat map feature. However, you can quickly and easily create a heat map in Excel using conditional formatting.
This tutorial explains a new Excel 365 function that helps you make an array bigger to the size you want by filling it with a chosen value. Do you need to expand an array to…
Filter in Excel is an essential tool that helps to display relevant data. It eliminates the irrelevant entries temporarily from the view. This tool filters data according to the criteria to help analyze the critical data points