To check the rows for duplicates, the formula first selects a column ($A$2:$A$14). This equation is true when it counts more than one row with the same information. If the answer is true, the formatting is applied. Let's take a closer look at this formula.Ĭonditional formating formulas have to return an answer that is either true or false. Set the Style to Classic, then open the next dropdown menu and choose Use a formula to determine which cells to format.ĬOUNTIFS($A$2:$A$14,$A2,$B$2:$B$14,$B2,$C$2:$C$14,$C2)>1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |