colour change if conditions met in straight table

[#1]

Hi Guys, I hope you can point me in the right direction.

Basically I'd like to change the font colour if certain conditions are met in a straight table

I've attached a QVW so you can see the problem.

So over to you and thanks for looking!

Jeff.

[tresesco · Accepted solution]

May be text color expression like:

If(max(if(DueDate>0 and Status=2,1,0))=1, rgb(0,255,0))

[prma7799]

Like this???

[Anonymous]

1. Expand the Expression in the straight table

2. Select Text Color option

3. Enter this: if(Status=2 or DueDate>0,RGB(0,255,0))

4. Ok

[#5]

Well that was great - two answers both correct and in double quick time - THANKS GUYS!