This is can be done using conditional formating

Proceduce:

From insertable object pan double click on query items which
ever u want

select the revenue data item, from the change layout menu
click on define conditional styles

Enter the new value 50,000 click on insert again enter the
new value 50,000 click on insert 

For one revenue 50,000 and greate select the style as you
want and for another revenue 50,000 and below select the
style or color as you like

Finally click ok

In c8 you can achieve this by following these steps
1)drag a conditional block
2) Assign a boolean variable(in expression box if(sal>50k)
to the conditional block
3) go to conditional explorer you find two conditions yes and no
4)when current block is yes...drag a layout calulation (sal-50k)
5) When current block is no... use select background color
of salary as gree