Complex Conditional Formatting
Breaking down complex logic into manageable chunks of code is the smartest thing you can do when it comes to conditional formatting. Especially when it needs to account for an increasingly wider number of conditions.
This week's video deals with what seems like a simple solution to solve, yet it comes with all kinds of complex little pieces to make the solution provide the end result desired.
If you enjoy the type of video which is a bit of a solution walk-thru, where I discuss how things are solved, then make sure to spend a bit of time with this technique and video.