Conditonal Formatting on Table Tool

Hi All,

I'm trying to achieve the Conditional formatting tp be dynamic on the Reporting Table Layout on column C & D using the Condition on column E

Attached the Sample Data for Reference with Input Data and Expected Output.

Any help would be appreciated.

Thanks

Sample Data.xlsx

Workflow

Developer

Developer Tools

Reporting

Output

Common Use Cases

Transformation

Accepted answers

Bren_Spill2

@suby - the logic is correct. The issue is that the amounts in your formula are decimals and the amounts in the percent column are not. I updated the formulas in the Table tool to reflect this and it's working now - see attached.

Conditional Formatting 2.yxmd

All comments

Bren_Spill2

@suby - see attached. Replicate for Percent column. Please mark as solution if this helps!

Conditional Formatting.yxmd

suby

Hi Bren,

Thanks for your reply and my expected output is when the percent is within that threshold I want the same colour to be applied on both the percent column and Achieved column.

I followed the same logic in the Expected Output and still the colours are not working could you help.

When the percent is

[Percent] > 0.25 I want the RED colour to be applied on percent Column and Achieved Column

[Percent] > 0.2 and [Percent] <= 0.25 I want the AMBER colour to be applied on percent Column and Achieved Column.

[Percent] <= 0.2 I want the GREEN colour to be applied on percent Column and Achieved Column.

Any help would be much appreciated.

Thanks

Conditional Formatting 2.yxmd

Bren_Spill2

Conditional Formatting 2.yxmd

suby

Thanks that's great . Many thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703