conditional formatting of a percent

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

Guest

I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%. I
have had no luck with the things I have tried. Any suggestions?
 
Using Conditional Formatting on the Format menu (in report design view), set
Condition 1 to:
0.5
Click to expand...

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

tracy said:
I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%.
I
have had no luck with the things I have tried. Any suggestions?
Click to expand...
 
tracy said:
I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%. I
have had no luck with the things I have tried.
Click to expand...


You can use Conditional Formatting (Format menu) on the text
box.
Field value is
Greater Than
.5

Or you can use a little code in the text box's section's
Format event procedure:

With Me.thetextbox
If .Value > .5 Then
.FontBold = True
.BackColor = vbYellow
Else
.FontBold = False
.BackColor = vbWhite
End If
End With
 
Thanks....that worked great!!
--
Tracy


Allen Browne said:
Using Conditional Formatting on the Format menu (in report design view), set
Condition 1 to:
0.5
Click to expand...

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

tracy said:
I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%.
I
have had no luck with the things I have tried. Any suggestions?
Click to expand...
Click to expand...
 
Back
Top