Access to Cells in Report 2DTable

[smoothdurban]

Hello,

I am trying to change properties of individual cells in a report based on content is this possible? 

For example I am trying to highlight values red that do not fall within a specified parameter.

I know that I able to access the font color of the entire column but I am trying to access the individual cell in the column

Is this possible?

I am using DIADem 2012 SP1

[Walter_Rick]

Hello Tim,

Yes that is possible. You need a user command which handles the color settings depending on the limits of channel values. This command is called in the table format settings and contains the variable CFV (current format value) as parameter. Please have a look at the attached example.

Greetings

Walter

[smoothdurban · Accepted solution]

Looks good.  I used the OnDrawingCell which I found in the examples.  It seems to work well.

Set Table = Report.ActiveSheet.Objects("2DTable1") 

  For i = 1 to 9
    Set Column(i) = Table.Columns.Item(i)
        Column(i).Settings.OnDrawingCell = transferCaseType
  Next
  
 Call Report.Refresh()