COUNTIF simply counts the number of times each value appears in the range. When the count is more than 1, the formula returns TRUE and triggers the rule.
When you use a formula to apply conditional formatting, the formula is evaluated relative to the active cell in the selection...Read more
When you use a formula to apply conditional formatting, the formula is evaluated for each cell in the range, relative to the active cell in the selection at the time the rule is created. So, in this case, if you apply the rule to B4:G11, with B4 as the active cell, the rule is evaluated for...Read more
When you use a formula to apply conditional formatting, the formula is evaluated relative to the active cell in the selection at the time the rule is created. So, in this case the formula =B4>100 is evaluated for each of the 40 cells in B4:G11. Because B4 is entered as a relative address, the...Read more
In this example, the goal is to return the middle name from a full name in "First Middle Last" format. In the current version of Excel this is a fairly simple problem using the TEXTAFTER and TEXTBEFORE functions. In older versions of Excel, a similar formula is significantly more complicated,...Read more
In this example, the goal is to compare two columns and return the count of matches in corresponding rows. A good way to solve this problem is to use the SUMPRODUCT function or the SUM function, as explained below.
The...Read more
In this article, we look at some cool ways that you can use Excel's conditional formatting feature to quickly visualize important data.Read more
In the Excel date system, one day is equal to 1, so you can think of time as fractional values of 1, as shown in the table below:
| Hours | Fraction | Minutes | Seconds | Value | Time |
|---|
In the Excel date system, one day is equal to 1, so you can think of time as fractional values of 1, as shown in the table below:
| Hours | Fraction | Minutes | Value | Time |
|---|---|---|---|---|
| 1 |
In the Excel date system, one day is equal to 1, so you can think of time as fractional values of 1, as shown in the table below:
| Hours | Fraction | Value | Time |
|---|---|---|---|
| 1 | 1/24 |
In this example, the goal is to write a formula that will return TRUE if a year is a leap year and FALSE if not. This is a surprisingly challenging problem in Excel for two reasons: (1) Excel thinks 1900 is a leap year due to a long-standing bug inherited from Lotus 1-2-3 and (2) The logic for...Read more
