Using Table Tools to Config Cell Color on two Criteria and then Sort by Value in a Column

[twildhart]

What I have been doing is taking my output and then making the necessary changes in Excel for presentation purposes. I would love to manage from input through to presentaiton so i started to play with the Reporting tools. You will see from my data that I also have a n opportunity to merge like cells for a cleaner view. I found a solution to that here. 

However, before I do the final beutification of the table, I would like to do some conditional color of rows. I see how to do that given one criteria, but I want to be able to do it by two criteria. I would like for the rule to verify the Data Type = Delta - then red if less than zero or green if greater than or equal to zero. I beleive I just hve to repeat this for each column. 

The final step is taking all of this data and sorting it from worst to best keeping the ID's organized in the order that they are with each in Actual, Plan, and Delta order. 

Below I share the incoming data and then how I would like it to look before I then do the cell merge. 

[nagakavyasri · Accepted solution]

@twildhart 

[binuacs · Accepted solution]

@twildhart Instead of repeating the rules, write the column rules in the dynamic or unknown field then it will automatically get reflected in the fields you add later in your input tool. Attaching a sample workflow for your reference