Conditional Formatting and Applying to Multiple Excel Tabs

JWuWuTang

Hi everyone,

I had a question regarding applying conditional formatting to an Excel file to multiple tabs and how to set that up in Alteryx. Currently, my process involves creating the rules in Excel, and then having to format paint each tab, but because I have so many tabs, it becomes very tedious. I figured that there must be a solution to do this in Alteryx, but because I am pretty new to Alteryx, wanted to see if I could find some help. 

I have attached two sample files and some screenshots, one of how I do my conditional formatting in Excel, and one sample file that I want to use as my Alteryx input. I've looked at some other posts regarding conditional formatting, but am having some trouble applying the Table tool and Column/Row rules, and then don't know how to apply it to each tab of my file.

Conditional Formatting Rules

Excel Conditional Formatting Sample.xlsx

Alteryx Conditional Formatting Sample.xlsx

AbhilashR

Hi @JWuWuTang, I put all the calculation in one formula. Is this what you are looking for?

IF [A] = 'Peaches' AND [B] = 'Peaches'
	THEN 'background-color:rgb(206,255,173)'
ELSEIF [A] != 'Peaches' AND [B] = 'Peaches'
	THEN 'background-color:rgb(255,255,0)'
ELSE Null()
ENDIF

Alteryx Conditional Formatting Workflow.yxmd