![]() ![]() This allows our formula to incrementally check each row. This time, the absolute location is used for the column, but not the row. The next variable is the target that we are checking for a duplicate value ($A2). ![]() ![]() We use the absolute location because we want all to use the same range of cells when evaluating rows for duplicates. 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 |