Conditional Formatting

[richmond88]

I have an application that tracks student grades.

The students do a benchmark test so that we can measure there progress during assessments, this is then measured against there current assessment and that assessment grade is colour coded depending it is up/down or on target against there benchmark grade.

eg. A student that has a benchmark of C the gets a D in the Assessment - this would show up as a yellow D showing the teacher that they had underperformed by 1 grade. Other colours used are Green for a grade better than assessment, white for on target and red for at least 2 grades below benchmarks. I hope you are still with me.

From the data, I create a crosstab query as laid out below.

Student name Maths English French

Paul Smith A B B
Pete Taylor C C C

At the moment I concatenate the Benchmark and the Actual Grade and I have a lookup table that would link to this concatenation and come up with a little graphic(gif). In the case of Maths. The concatenation would be AA and this would show a littlE White Square with a Black. The 2 B's as Yellow Squares with Black B's.

Is there a better way of doing this.

Thanks

Chris

 

[snyperx3]

If txtBoxName.Value = "A" Then
     txtBoxName.BackColor = vbWhite
End If

for each one...or

Select Case txtBoxName.Value
     Case "AA"
          txtBoxName.BackColor = vbWhite
     Case "BB"
          txtBoxName.BackColor = vbYellow
End Select

Just put this in your vba where ever the change takes place.

-Pete

 

[richmond88]

Thanks for the reply SNYPER. I could get that to work but there would be too many options in the case statement and it would turn out quite messy.

Thanks anyway.

Chris

 

[TheAceMan1]

[/blue richmond88][/quote] . . . this would show up as a yellow D showing the teacher that they had underperformed by 1 grade.[/blue][/quote]
Would'nt numeric indicators (+2 +1 0 -1 -2 -3) show performance more directly to the eye than deciphering color codes?

See Ya! . . . . . .

 

[richmond88]

It would but they need to know the grade.

Chris