Conditional Formatting

  • Thread starter Thread starter rama
  • Start date Start date
R

rama

Hello,
I wish to make a conditional formatting in the monthly overtime
report. For that in my report there is an average overtime percentage
'txtAverage', each employee's overtime percentage 'txtPercentage' and
each employee's overtime Total 'txtTotal'. If any employee's overtime
(txtPercentage) is more than 5% of average (txtAverage) then that
employee's name and txtTotal should be highlighted with different text
color in bold letters. I tried a lot with my ideas but no result.
Kindly help me to resolve this.
Rama
 
Is one of the attempts to format include the expression (in the dialog box
for conditional formating) looking like the following?

expression = [txtPercentage] >= .05

Just an idea.

Jeff
 
Did another look.

With your form in design mode.

select your text box. bring up your conditional formating dialog

under condition 1
Ensure the first combo box reads "Field Value Is"
Then make sure you select in the criteria combo box "greater than or
equal to" (towards the bottom of the list)
In the value box, type in ".05" (without the quotes)

Set your formatting and click okay.
 
Is one of the attempts to format include the expression (in the dialog box
for conditional formating) looking like the following?

expression = [txtPercentage] >= .05

Just an idea.

Jeff



rama said:
Hello,
I wish to make a conditional formatting in the monthly overtime
report. For that in my report there is an average overtime percentage
'txtAverage', each employee's overtime percentage 'txtPercentage' and
each employee's overtime Total 'txtTotal'. If any employee's overtime
(txtPercentage) is more than 5% of average (txtAverage) then that
employee's name and txtTotal should be highlighted with different text
color in bold letters. I tried a lot with my ideas but no result.
Kindly help me to resolve this.
Rama- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

This way it works fine. Thank you very much for the help and advice.
Rama
 
Back
Top