conditional colored borders around data in report

M

MeredithS

I have a report that's based on a crosstab query. In the report, I'd like to
be able to outline with one of 2 colors variables that meet specific
parameters, e.g., If "Qtr 1" is between 90.0 and 92.5, I'd like it to be
outlined with a yellow border. If variable "Qtr 1" is < 90.0, I'd like to
outline it in red. Same with the other values from the query.

Is that possible and, if so, how -- I don't have an idea where to start,
actually.

Thanks,

Meredith
 
A

Al Camp

Meredith,
Set the Default BorderColor to White, not Transparent.
I'm assuming, from your post, no values greater than 92.5.

Use the OnFormat event of your Detail section (if that's where your Qtr values list)

If [Qtr 1] >= 90.0 and [Qrt 1] <= 92.5 Then
[Qtr 1].BorderColor = QBColor(14)
ElseIf [Qtr 1] < 90.0 Then
[Qtr 1].BorderColor = QBColor(12)
End if
(use RGB function for customized colors)
 
Top