Highlight or print * for any hours over 80

  • Thread starter Thread starter JWeaver
  • Start date Start date
J

JWeaver

I have a report that prints total number of hours worked by employees during
a specific reporting period. The employee submits their time sheets but
sometimes they submit old time sheets as well so that their total number of
hours for the pay period will be over 80 hours.

Is there a way to highlight or place an asterisk beside of the total if it
is over 80 hours? I want to be able to view this information quickly so that
the hours can be checked to ensure that they are correct.

Your assistance is greatly appreciated!
 
Perhaps conditional formatting would do what you want. Click the text box
that contains the hours, then click Format >> Conditional Formatting. In
the dialog that appears select Field Value Is in the left box, select
Greater Than in the next box to the right, and enter 80 in the box after
that. Select a background color or font color to be used if the value is
greater than 80.
If the hours text box is a calculated value I think you will need to select
Expression Is in the Conditional Formatting dialog. In the next box:
[Field1] * [Field2] > 80
Use the actual expression that calculates the value. I just plugged in a
generic expression to illustrate.
 
Thanks, Bruce. The conditional formatting worked with the Field Value is
option set.
--
JWeaver


BruceM said:
Perhaps conditional formatting would do what you want. Click the text box
that contains the hours, then click Format >> Conditional Formatting. In
the dialog that appears select Field Value Is in the left box, select
Greater Than in the next box to the right, and enter 80 in the box after
that. Select a background color or font color to be used if the value is
greater than 80.
If the hours text box is a calculated value I think you will need to select
Expression Is in the Conditional Formatting dialog. In the next box:
[Field1] * [Field2] > 80
Use the actual expression that calculates the value. I just plugged in a
generic expression to illustrate.

JWeaver said:
I have a report that prints total number of hours worked by employees
during
a specific reporting period. The employee submits their time sheets but
sometimes they submit old time sheets as well so that their total number
of
hours for the pay period will be over 80 hours.

Is there a way to highlight or place an asterisk beside of the total if it
is over 80 hours? I want to be able to view this information quickly so
that
the hours can be checked to ensure that they are correct.

Your assistance is greatly appreciated!
Click to expand...
Click to expand...
 
Back
Top