. The Conditional Formatting window appears.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. |
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")
|