Conditonal Format on a Field based on Percentage value

I have a field [x_wrong] on a form that has a numerical value. The number can
fluctuate wildly, so I need to base the colour change on a percentage instead
of a fixed value or range. Does anyone know how to do this?

"efandango" wrote

I have a field [x_wrong] on a form that has a numerical
value. The number can fluctuate wildly, so I need to base
the colour change on a percentage instead of a fixed value
or range. Does anyone know how to do this?

A percentage of _what_?

Larry Linson
Microsoft Access MVP

Duh!, sorry Larry. It was late when I posted this message and I forgot the
important bit...

In my table, i have a list of numbers representing the amount of times a
user has got a question wrong, based on the field [x_wrong].

for example:

[Qstn_ID] [Xrwong] [Question] Colour

4 15 blah, blah Green
6 9 " Green
18 27 " Red
4 43 " Red
9 4 " Blue
2 8 " Green
33 3 " Blue
9 3 " Blue
84 22 “ Red

I want to be able to colour code the 3 ranges available, based on the
highest 3rd, middle third, and lowest 3rd percentages of the values using the
fluctuating highest value, and lowest value as the index. Because the values
are constantly changing, i cannot use a fixed figure; say 33 because the
highest value may never reach 33.


"Larry Linson" wrote:

"efandango" wrote

I have a field [x_wrong] on a form that has a numerical
value. The number can fluctuate wildly, so I need to base
the colour change on a percentage instead of a fixed value
or range. Does anyone know how to do this?

A percentage of _what_?

Larry Linson
Microsoft Access MVP

Can anyone help with this?...

"efandango" wrote:


In my Form/table, i have a list of numbers representing the amount of times a
user has got a question wrong, based on the field [x_wrong].

for example:

[Qstn_ID] [Xrwong] [Question] Colour

4 15 blah, blah Green
6 9 " Green
18 27 " Red
4 43 " Red
9 4 " Blue
2 8 " Green
33 3 " Blue
9 3 " Blue
84 22 “ Red

I want to be able to colour code the 3 ranges available, based on the
highest 3rd, middle third, and lowest 3rd percentages of the values using the
fluctuating highest value, and lowest value as the index. Because the values
are constantly changing, i cannot use a fixed figure; say 33 because the
highest value may never reach 33.


"Larry Linson" wrote:

"efandango" wrote

I have a field [x_wrong] on a form that has a numerical
value. The number can fluctuate wildly, so I need to base
the colour change on a percentage instead of a fixed value
or range. Does anyone know how to do this?

A percentage of _what_?

Larry Linson
Microsoft Access MVP

I am affraid we still cannot see what you are calculating the
percentage on.

for instance, why is the first one green? 15 is being divided by what
to derive what percentage?

[Qstn_ID] [Xrwong] [Question] Colour

4 15 blah, blah Green
6 9 " Green
18 27 " Red
4 43 " Red
9 4 " Blue
2 8 " Green
33 3 " Blue
9 3 " Blue
84 22 " Red

Ron

Thanks Ron, I have now seen the light you and Larry have been trying to shine
down my tunnel of vision...

I had mental 'fix' on 3 sets of figures, Low, Med, and High (constantly
changing, constantly growing), and I was expecting 'Conditional Format' to do
the maths, without a common demonitator!... I have since resolved the
problem, using just a Low and High box and getting 'Conditional Format' to do
some logic on those two figures, with the constantly adjusting 'middle' being
left as the Default Condition. It worked a treat. I now have a continous form
'column' seperating into 3 colour bands representing the Low, Mid, and High
values.



"Ron2006" wrote:



I am affraid we still cannot see what you are calculating the
percentage on.

for instance, why is the first one green? 15 is being divided by what
to derive what percentage?

[Qstn_ID] [Xrwong] [Question] Colour

4 15 blah, blah Green
6 9 " Green
18 27 " Red
4 43 " Red
9 4 " Blue
2 8 " Green
33 3 " Blue
9 3 " Blue
84 22 " Red

Ron

We are both glad that the light popped on.

When I was teaching, I always operated on the theory that my job was
to phrase the information in some manner that would connect with the
student.

If the student didn't understand it then I had to say it some other
way so he/she could make the connection. Repeating the same
information the say way would probably not get either of us anywhere
(even if it was perfectly clear to me.)

Have a great day.

Ron