If the formula evaluates to `TRUE` (or any non-zero value), Excel applies the formatting. If it evaluates to `FALSE`, `0`, or an invalid value, no formatting is applied.

Compared to Excel formulas, Power Query is more efficient, automates processes, reduces errors, and simplifies complex operations, making it a superior tool for handling data workflows.