Output Data - Highlighting Record

[suby]

All,

In my workflow after doing some transformations i have created new field called 'Replace' where if its 1 then Record is Modified and if its 0 then no Change.

In my sample Data i have Sheet and Sheet 2 as Input Data with the Replaced flag.

I'm looking for a solution where i want to highlight the Record in 'Orange' Color if the Replaced Column value is = 1 in my output file.

Input = Sheet 1 & Sheet 2

Expected Output = Expected Output Sheet 1 & Expected Output Sheet 1

Thanks

[christine_assaad]

Hi @suby 

You can do this by using Alteryx Reporting tools. You can use a Table and set rules as below.

You can then use the "Render" tool (equivalent to Output tool) to write your data to Excel. Cheers!

[IraWatt]

Hey @suby,

Adding on @christine_assaad's post you can use a layout tool before the render to split the tables into different tabs like this:

Any questions or issues please ask :)
HTH!
Ira