Adding a colour gradient to a table/pivot table

[krisk]

Hi

I am looking to add some conditional formatting style background colours to my tables/pivot tables. It would be nice to be able to have a colour gradient where dark green is the highest value in the column and dark red is the lowest value in the column.

I am aware that you can use expressions to color by expressions but I am unsure about how to write an expression to do this.

Is there another way to achieve this? or will I have to find a way to use expressions?

Also, are there any other ways we can add conditional formatting style backgrounds in our tables, such as sparklines, data bars etc?

Many thanks for reading and any help you can give me.

[Chanty4u]

May be this 

Click on the "Appearance" 

Then "Conditional" under the "Background Color" section.

Select expression 

=ColorMix1(

FirstSortedValue(FieldName, -FieldName),

FirstSortedValue(FieldName, FieldName),

0.5)

[krisk]

Hi

Thank you for this.

The column in the pivot table that I was trying to add a colour gradient to is populated with a measure, and it seems like I cannot put a measure into this calculation.

For reference, my measure is called 'Total Orders'.