![]() ![]() We are doing this breakdown for cells C5 and D6. Write down the following formula into the empty box below Format values where this formula is true.Now, choose the Use a formula to determine which cells to format option.In the Home tab, select Conditional Formatting > New Rules.For beginning this process, select the entire range of cells C5:D14.The procedure of this method is given below: The dataset contains the scale of Points in column B and the name of the employees of an institution for the month of January and February in columns C and D respectively. Our dataset is in the range of cells C5:D14. In this following method, we are going to use the AND and COUNTIF functions to highlight duplicates in multiple columns in the Excel datasheet. Read More: How to Highlight Duplicates in Excel with Different Colors (2 Ways) In the end, we can say that our highlighting process and formula worked successfully. You will see the duplicate values of columns C and D get our chosen highlight cell color.Again click OK to close the New Formatting Rule box.Click OK to close the Format Cells dialog box.You will also see the cell color in an enlarged form in the Sample section. Then, in the Fill tab select the cell fill color.Here, we first go to the Font tab and choose the Bold option. Another dialog box called Format Cells will appear.After that, write down the following formula into the empty box below Format values where this formula is true. ![]()
0 Comments
Leave a Reply. |