![]() Since the range parameter in the formula uses absolute referencing, the range remains fixed. This is where absolute and relative referencing are important. The Conditional format rules will use the Apply to range setting, moving down each cell in the range, applying the formula. In our formula, we’ve provided cell A2 as the criterion, but passed it as a relative cell reference (no $ symbol). When setting the range parameter in the COUNTIF function call, we need to use absolute cell referencing (we’ll see in a second why), hence we prepend both the column letter and row number with the dollar symbol, $A$2:$A$25.ĬOUNTIF then uses the criterion parameter, checking it against all the cells in the range, incrementing a counter every time a match (i.e. In our example, the range of cells used is from A2 to A25 inclusive. Otherwise, criterion may be a string containing a number (which also checks for equality), or a number prefixed with any of the following operators: =, >, >=, 1ĬOUNTIF takes two parameters, the range ( $A$2:$A$25), and the criterion ( A2), and what we are looking for is a count that is greater than 1. If a number is provided, each cell in range is checked for equality with criterion.
0 Comments
Leave a Reply. |