VB6 Data Report, how to control color at the row level

[CruiseMan]

I am generating a VB6 DataReport. A user has asked me if I can change the color of the data in certain columns based upon whether the data value falls within a set of limits. This means that these columns have to be evaluated on a row by row basis. I have not been able to find a way to do this in Visual Basic within a DataReport. Does anyone know of a way to do this, short of exporting the report into something like an Excel template?

Thanks for any help.

 

[MichaelRed]

Conditional Formatting?



MichaelRed

 

[CruiseMan]

I considered conditional formatting, but with MS DataReport, the entire column is formatted according to the condition satisfied. However, I may be able place an additional column (1 char. wide) beside each data column I need to flag and populate it with a color formatted character or leave it blank based upon the results of the comparison for each record in the recordset.