Conditional formatting doesn't seem to work no matter what I try

[Anonymous]

I'm trying to break this down to the most simplest form of conditional formatting, so I'm struggling to understand if it's intended to work the way I have in my head.  Let's say I have a table such as the following:

Price1  Price2   %Diff

100      50        -50%

When using a standard table, all I'm trying to do is have the font color of the values in the %Diff column to display in red when it's a negative value.  Seems like no matter what kind of rule or color scale option I try, I can't seem to pull it off!  I know it has to be something that's obvious to everyone else, but reading other posts and watching videos I can't seem to apply that same logic to my simple needs.  If anyone has any suggestions please help 🙂

Thanks!

[RMDNA]

Hi @Anonymous,

I'm not running into similar issues. Are your rules set up like below?

[Anonymous]

I just spotted in another thread that the conditional formatting won't work if your table only contains values.  Is this true and why you had to add that attribute field??  I don't want/need any text in my table.

[RMDNA]

@Anonymous,

If you have no attributes, your measures will be a table with only a single row. If the %Diff only needs to be seen as an aggregate value, I would recommend showing the values in cards as a high-level KPI.

Could you expand on what you're trying to display, and how?