A few weeks ago, we launched the new Filtering UX. You no longer need to write formulas to filter your data.
We’ve now brought the same experience to Conditional Formatting. As soon as you choose a column, we’ll automatically offer you simple controls to set up your rules.
We continue to allow you to use formulas as before by just choosing the formula option when adding a rule. We also built a way for you to see the underlying formula for any builder, to make it easier to learn the formula language and have even more control. You can use the same method to convert most of your existing conditional formats into the new experience.
Finally, we’ve also made it easier to format a whole column by simply choosing a column and a format. Whenever you choose a format without a condition, it will now apply to all rows by default.