Conditional Formatting based on Dynamic Field Value, using Table Tool

[ValeriaK]

Dear Alteryx Community Experts!

Need you expert advise on the following case please.

Conditional Formatting needs to be applied on each individual Customer Column based on the 2 Standard Deviation calculation/value displayed at the end of each Customer Column.  

I assume it would be an individual column formula for each customer that would reference the value indicated in the "ORDER_COUNT_2STDDEV_BELOW" and compare it to each value in the customer's column?

Here is the issues I'm facing with my approach in the attached workflow:

1. applies conditional formatting correctly to the 1st customer only.

2. conditional formatting should exclude the last 4 total rows 

3. doesn't work in couple with Row Rules (bold total rows)

Bold Last 4 Total Rows: (Row formula used)

REGEX_Match(ToString([_currentfield_]),'Total|ORDER_COUNT_MEAN|ORDER_COUNT_2STDDEV_BELOW|ORDER_COUNT_STDDEV')

Desired Output:

Where

Customer 1: Highlight Column Value in yellow where it's equal or less than the value indicated in "ORDER_COUNT_2STDDEV_BELOW". In this case it should compare each [Customer 1] column value to 231

* (all 29 column values, where [ORDR_DATE] is date, excluding last 4 total rows)

Customer 2: 

Highlight Column Value in yellow where it's equal or below the value indicated in "ORDER_COUNT_2STDDEV_BELOW". 

In this case it should compare each [Customer 1] column value to 6 

Etc...

Alteryx Workflow and Desired output attached.

Thank you in advance!

[geraldo]

@ValeriaK 

I'm analyzing your workflow. the total line has punctuation and I believe that everything should be treated as a number and not a string and you format it in your report.

just to change the entry without the "," in TOTAL the formatting formulas already worked

[albert_alaluf · Accepted solution]

Hi @ValeriaK 

Let me know this works for you.

[ValeriaK · Accepted solution]

Looks Amazing albert_alaluf! This is exactly what I needed. Really appreciate your help! Thank you very much!!!