Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sure use the standard functionality built in Access. Look under format -
conditional formatting. That should do the trick for your question.

hth
 
Back
Top