![]() Then there’s the definition of duplicate. You can compare values in the same list or you might want to compare one list to another. ![]() Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.Ĭomparing lists for common values, or duplicates is a task that often has many variables. Here we discuss how to Use Conditional Formatting based on Another Cell Value along with practical examples and a downloadable excel template.How to use Excel’s conditional formatting to compare lists This has been a guide for Conditional Formatting based on Another Cell Value in Excel. Similarly, we can use the other criteria by entering different conditions under the Formula text box, depending on your requirement.In this article, we have used text criteria for highlighting the row or cells based on another cell value.This process will highlight the entire rows having Pending status.When Cell A5 is checked for the condition, it will check Cell E5 and so on.When Cell A4 is being checked for the condition, it will check Cell E4.We have locked the column E, Delivery Status, which we are looking for.We have used the $ sign before the column alphabet ($E3).If it does, that rows get highlighted else, it doesn’t. Starts from Cell A4 will check whether the cell E4 has the delivery Status Pending or not. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |