Open topic with navigation

> Home / Herb 50 Payroll / Example: Conditional formatting
See also

Conditional formatting

Herb 50 Payroll example: Conditional formatting

Conditional formatting examples

To set conditional formatting, select the item you want to work with then from the Properties pane select Conditional Formatting and click the finder button . The Conditional Formatting window appears.

Purpose

Expression
Highlight employees who have taken less than 5 days holiday. 
Employees.HolDaysTaken < 5

On the Properties tab, select the colourcolor you want to use from the Text Style options.
Highlight absences since a particular date.

Highlight absences with a start date since 1 August 2013:

AbsenceHistory.AbsStartDate >= #2013-08-01T00:00:00#

On the Properties tab, select the colourcolor you want to use from the Text Style options.
Highlight employees with over 20 days remaining holiday.

On the Filter tab, click Edit, then select Use Advanced Filter. Enter the expression:

((Employees.HolDaysBF + Employees.HolDaysCF + Employees.EmployeeEntitlement) - (Employees.HolDaysTaken + Employees.HolDaysBookedThisPayPeriod)) > 20

On the Properties tab, select the colourcolor you want to use from the Text Style options.

Advanced conditional formatting examples

The following examples use advanced conditional formatting. Before you try these examples, choose Tools > Options, then select the Options tab and enable Use Advanced Conditional Formatting.

Purpose

Expression
Highlight employees that have left in red text. 
If Employees.WorkEndDate <> NULL
then
  TextStyle->Color := NamedColor("Red")
else
  TextStyle->Color := NamedColor("Black")
Highlight employees with over 20 days remaining holiday in red text. 
If ((Employees.HolDaysBF + Employees.HolDaysCF + Employees.EmployeeEntitlement) - (Employees.HolDaysTaken + Employees.HolDaysBookedThisPayPeriod)) > 20
then
  TextStyle->Color := NamedColor("Red")
else
  TextStyle->Color := NamedColor("Black")

Go to top