How do i conditionally format the background color of a field on a straight table?

[#1]

How do conditionally set the background color of a field on a straight table chart based on another field within the record?

Also, can the background color of an entire row on a straight table chart be set conditionally or will i have to set each field individually?

Thanks

[#2]

Coniditional coloring can be done like the following:

=IF(RIGHT(Account_Number,1)='1', GREEN(), RGB(100,100,100))

Silly expression but you can use the THEN and ELSE to determine your colors. Notice that if the furthest right 1 character is 1 then the background will use the QV system function for the color GREEN, while if the character is not a 1 then it will use the explicitly defined RGB color value.

Your IF statements can be nested as they can in any circumstance like

=IF(MyExpression , GREEN(),

   IF(MyOtherExpression, YELLOW(),

     RED()))

There is no way I know of set the background color for the entire row conditionally.

[#3]

To format the row, you just need to apply the same conditional colouring statement to each and every 'Used Dimension' in the 'Dimensions' tab or Expression.