In the worksheet, cell E2 is named “date”.
Here is another article onConditional formatting based on a different cell.
If both return TRUE, AND returns TRUE and the conditional formatting is triggered.
The formula looks like this:
There are two main parts of the formula.
On the right, the same thing happens with the date in date ($E$2).
Effectively, this ignores day completely by making it the same for each date.
Finally, the two dates are tested for equality.
You’ll find these kind of tricks are everywhere in more complex Excel formulas.
Like #4 above, the result is the same as concatenating the month and year manually.
It’s hard not to be delighted by a clever and efficient formula.
But all that said, Excel is a vehicle, not a destination.
Are you looking formore conditional formatting formulas?
