Conditional Formatting Updates

[Mark]

We recently launched a few updates to conditional formatting:

1. You can now apply one conditional formatting rule to multiple ranges:

   

2. Format formulas now “drag” over their range

   

   In the example above, the format formula ‘=B3*1.1’ drags down and to the right across the range. So cell G8 evaluates as greater than ‘F8*1.1’ and the conditional formatting is applied.

[Ron81]

Can you write a custom formula for the condition in conditional formatting?

[Mark]

yes you can select Custom Formula for the Condition and then write a custom formula to apply conditional formatting. Here’s an example that conditionally formats the max value in each column.