Forum Discussion

lscoffield's avatar
lscoffield
Frequent Visitor
6 years ago
Solved

Table change row color depending on value

How do I change the font color of a row depending on the value of a column? Say if a column equals "changed" how do I make the row font color red? Is that even possible?
Need Help
  • simrantuli's avatar
    simrantuli
    6 years ago

    Hi lscoffield ,

    Yes, it's very much possible.

    Create a new measure.

    Color = IF(Column= "Changed", "Give HEX Code of the color","Give HEX Code of the color that you want if the column is not "changed"').

    And then use this measure under 'Conditional formatting'.

    Enable 'Font Color'. A new dialog box will open.

    Select 'Field value' under 'Format by' and select the newly created measure under 'Based on field'.

    Regards

    Simran Tuli

     

simrantuli's avatar
simrantuli
Icon for Continued Contributor rankContinued Contributor
6 years ago

Hi lscoffield ,

Yes, it's very much possible.

Create a new measure.

Color = IF(Column= "Changed", "Give HEX Code of the color","Give HEX Code of the color that you want if the column is not "changed"').

And then use this measure under 'Conditional formatting'.

Enable 'Font Color'. A new dialog box will open.

Select 'Field value' under 'Format by' and select the newly created measure under 'Based on field'.

Regards

Simran Tuli

 

SGVACG's avatar
SGVACG
Frequent Visitor
4 years ago

This only changes the color of the font in one column, not the whole row.