Conditional formatting

[espenzaal]

Hello!
I am stuck with a problem in my database.
I got a table that is looking like this:
On_Time
95%
96,88%
100%
100%
97,56%

There is more data there but this is the field i want to use. I got a form where i want a little box or something to be coloured in red if the average of all those percentages are below 95%. If its above 95% it should be green.
Can anyone help?

 

[espenzaal]

Please dont reply to this thread after all. I dont know how to delete it so i will just reply liek this hoping its no problem for anyone