How to change color in visual cues of straight table

[#1]

hi guys,

Please help me, how do i change color of field amount in straight table depending uopon below criteria.

i have a table having field 'amount'

Now i want to change color of amount field depending upon sales stage

if i click a field " closed won" in  "sales stage" list box then color of amount should get change to Green....

if i click a field " closed lost" in  "sales stage" list box then color of amount should get change to red....

[vikasmahajan]

  Select Expressions - >Background  and give condition

=if(column(3)>0.001 and column(2)>0.001,if(column(3)>column(2),rgb(0,182,0),rgb(247,247,247)),0)

Hope this help you

Vikas

[#3]

Hi vikas....

my selection criteria is on list box field.....

sales stage is a list box

and closed won and closed lost are fields.....

please go though my 1st post .....

[sureshbaabu · Accepted solution]

Hello,

Try the following on ‘text color’ for the expression

if(sales_stage='closed won',Green(),red())

Hope it helps. thanks