Select the ‘ Conditional Formatting’ option.Click the Format menu from the menu bar.Here’s how you can use Conditional formatting to highlight duplicate data: ![]() That would make more sense for our sample data too wouldn’t it? You might want to know which ingredients of a cake are also used in baking cookies. So far, the techniques we discussed mainly found out if cells in the same row were matching.īut what if you want to compare two columns and find out which values of column A are repeating in column B, irrespective of which row it’s in? Using Google Sheets Conditional Formatting to Compare Two Columns and Find Matching Data For example, you could use a formula like: = IF ( C2 $B2 You could use any operator or formula you’d like to show results for as a logical expression. Just like in the above example, you could use an IF statement on numerical data. You should now see the results of each comparison as “ Matching” or “ Not Matching” in column C.Ĭompare Two Columns and Show Meaningful Text From Numerical Values
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |