Fabric Plan Community Logo
Sign in

SETCFRULES

You can enable or disable conditional formatting rules using this function. Note that the rule should already have been created to be able to refer to it in the function.

Syntax#

SETCFRULES(CFRULE.RULE_NAME, BOOLEAN_ARG)

Arguments#

RULE_NAME – The name of the conditional formatting rule to be set.

BOOLEAN_ARG - Set to TRUE to enable the rule. Set to FALSE to disable the rule.

Example#

SETCFRULES(CFRULE.[Data Bars - Profit], TRUE) #Enables the data bar rule set for sales
SETCFRULES(CFRULE.[Sequential - Sales], FALSE) #Disables the data bar rule set for sales
SETCFRULES(CFRULE.[Sequential - Sales], THIS) #Disables the data bar rule set for sales
Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.