For instance, if you remove the apostrophe character in Bob’s, the items no longer match. For example, the rule highlights the last value, Mishi Kobe Niku because the corresponding cell in column C is blank. The lists don’t have to match in size either. This rule works with values as well as text entries. To apply the rule to column B instead, you’d use the rule =COUNTIF(B2:B2,C2)=0 after selecting C2:C11. It doesn’t highlight values that occur in both columns as the built-in rule did. This rule doesn’t highlight duplicates any value in column B that contains a value not in the corresponding cell in column C is easy to identify thanks to the cell’s contrasting fill color. The highlighted items in column B don’t match the corresponding value in column C. This rule will highlight items in column B that don’t match the corresponding items in column C.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |