Hi all,
I have a form that displays various metrics for all the different units
within the org.
It looks like below:
Unit Metric
A 72%
B 79%
C 82%
I want to have a different conditional format for Unit A than for Units B
and C. Basically, if Units B and C are < 80%, the font should be Red. I
want Unit A to be Red if it is < 70%. Is there a way to do this? Any help
is greatly appreciated.
Thanks,
ME.
Maurice - 31 May 2007 19:16 GMT
Sure use the standard functionality built in Access. Look under format -
conditional formatting. That should do the trick for your question.
hth

Signature
Maurice Ausum
> Hi all,
> I have a form that displays various metrics for all the different units
[quoted text clipped - 13 lines]
>
> ME.