Colur coding in Straight table

[#1]

Hi all,

I have an expression in straight table need to color code it

num([My field 1],'#,##.##M') & '  /  ' & num([My field 2],'#,##.##M')

If field 1 Great than 40 M compare to field 2 , Field 1 need to be red. tried different methods but not working.

Thankyou

[Anonymous]

just write in the Visual Clues tab

if ([My field 1]-[My field 2]>40, rgb(255,0,0))

you might adjust the numbers according to your Format (maybe > 40000000 if it is millions)

[maxgro]

or in text color

[#4]

Thankyou but i need it  this way

[Anonymous]

One cell - one color, sorry.

Unless there is an extension for this, that is unlikely.

[JonnyPoole]

Disable vertical expression cell borders ? and use 3 expressions   (measure 1 , '/', and measure 2)

[rajkumarb]

Hi Vamsi

Hope this example helps

[anbu1984]

Create another table and remove caption and place it on original table