You could have used conditional formatting in Excel very frequently, but have you ever tried applying conditional formatting across different work sheets in Excel? Yes, it is possible to apply conditional formatting across worksheets or workbooks in Excel; it is a very simple process. This tutorial will help you understand how we can apply conditional formatting across worksheets in Excel. Applying Conditional Formatting across Worksheets/Workbooks Here, we will first get the data into one sheet and then apply the conditional formatting to the acquired data. Let's look at a quick way to apply conditional formatting to multiple worksheets ... Read More

You could have added different colours to cells in Excel, but have you tried adding different shades of the same colour to the cells? It is possible to add shades of the same colour to the spreadsheet cells. Adding shades of the same colour will look better than using different colours. This tutorial will help you understand how you can add a colour gradient across multiple cells in Excel by following some simple steps. Applying Colour Gradient Across Multiple Cells in Excel Here, we will first apply the conditional formatting to cells and select gradient colours. Let us ... Read More

When we are using Excel, we want to add different colours to cells to create a design that can improve the neatness of the data. This also makes the excel sheet look nicer and allows for faster data analysis. This article will help you understand how we can apply color-banded rows or columns in Excel. This can be done using a simple method in Excel by using conditional formatting and applying different colours. Read this tutorial to learn a simple process to apply color-banded rows or columns in Excel. Applying Colour Banded Rows or Columns Using Conditional Formatting ... Read More

We could have created many types of charts in Excel and customised them to get our output, but the customization of charts could be a time-consuming process. If there is any type of chart that we will be using more frequently and which is not the default type in Excel, we can save the template of it in order to access it very quickly. We can save a template by selecting the existing chart and right-clicking and selecting "Save as template" from the menu box. Read this tutorial to learn how you can apply a template to an ... Read More

Have you ever tried to access the data in two workbooks at once? You could have compared data in two sheets of the same workbook using the VLOOKUP function. We can also connect the two worksheets in Excel. This process can’t be completed using the formulas; we will need to use the VBA code. This tutorial will help you understand how we can apply a button to open another workbook in Excel. Applying a Button to Open Another Workbook in Excel Here we will first insert a shape and then assign a macro to it. Let us see ... Read More

In this article, we will learn how to compare two adjacent strings in excel for identifying differences or similarities. Two methods have been explained in this article as mentioned below. Compare two strings for similarities using a formula. Compare and highlight two strings for similarities or differences using VBA Code. Compare Two Strings for Similarities using a Formula Step 1 − A sample data has been taken as shown below to compare the strings of two columns. Step 2 − Now, enter the following formula in Match Result column and drag the same till the last row to which ... Read More

If you want to compare two or more columns to find duplicate values, it can be done using a formula mentioned in this article. Many times, we come across a data set where values are entered repeatedly and required to be filtered. Let’s see how this can be achieved. Compare Two or More Columns Using a Formula Step 1 − We have taken sample data as shown below having two columns with some duplicate values. Step 2 − In the column C, we will identify the duplicate and unique values using the below formula. IF(ISERROR(MATCH(B3, $A$3−$A$10000, 0)), "Unique", ... Read More

To compare the values of two or more cells there are multiple formulas that can be used. For example, MATCH, If(A=B), EXACT, COUNTIF, etc. Here we will be learning the following two functions to find the exact match or where the formula will compare the strings without considering the case of strings. EXACT − To find the exact match. COUNTIF − To find similar values. Compare Multiple Cells for Equal Values Step 1 − Following is the sample data that we have taken for comparing the strings/cell values in a datasheet. Step 2 − Here, we have ... Read More

If we want to compare a date in an excel sheet with all other dates available in the sheet, then manually doing this activity will be very tedious and time taking. For this activity, we can use a formula that may give the comparison in one shot. Let’s learn how to use this formula to compare the dates. Compare Dates to Check if a Date is Greater than Another Date Step 1 − Below is the sample data that we have taken for comparing the dates. In the first column, we have taken the dates with which comparison needs to ... Read More

It usually happens with huge data that we might get multiple workbooks having worksheets of same name. Due to this we need to check all the similar sheets to get any specific value related to that sheet name. In this article, we will learn how to merge the worksheets having same name. By using the following method, we can combine the worksheets of same name into a master worksheet. Combine worksheets of same name into one worksheet using Copy and Paste command Step 1 − Here we have taken the sample data in two separate workbooks having sheets with same ... Read More