Conditional Formatting

[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

 

[Jeff @ CI]

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

 

[Jeff @ CI]

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.

 

[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

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 -

- Show quoted text -

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