How Form 2350 Toggle 2023-2024

Hello and welcome back to Tips and Timesavers. I'm Danny Rocks. This is a sequel to my previous episode where I introduced you to conditional formatting. In this episode, I'm going to demonstrate three techniques. Number one is how to extend to a new range the conditional formatting that we have in place. Number two is how to sort a dataset using cell color. This is a new feature that was added in Excel 2007. And finally, for the third technique, how to add a check to the workbook so that we can toggle on and off the conditional formatting that we have in place. In the previous episode, a viewer had contacted me to say, "Danny, is there a way that Excel can dynamically apply a background color to a cell based upon how many days it has been since our last contact with a customer?" Now, you can set up conditional formatting using a formula, a formula that responds true. So, the reason that the cell has the dynamically applied green cell background is because it answered true to this rule: it is a date that is within 60 days of today. The reason that the cells that have the orange color are dynamically shaded is because they follow this rule: it's an "and" rule where all logical tests must respond true. And the reason that the cells that have the red background color automatically applied with conditional formatting is because they answer true to this question: the date of last contact has been longer than 90 days. Alright, now what I've done is I've added in three new customers. Then, you can see the number of days and also whether it's been less than 60 days since our last point of contact. What we want to do...