Conditonal Formatting on Table Tool

[suby]

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

[Bren_Spill]

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

[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

[Bren_Spill · Accepted solution]

@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.

[suby]

Thanks that's great .  Many thanks.