![]() ![]() Select the first list of data you want to compare to the second one, for instance, A2:A7, then click Home > Conditional Formatting > New Rule.Ģ. ![]() In Excel, you can use the Conditional Formatting function to automatically shade the rows or cells if two columns equal.ġ. Method A Conditional formatting rows or cells if two columns equal ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |