Advanced Conditional Formatting

Conditional Formatting The Org Chart

This guide walks through the process of creating advanced conditional formats. The SharePoint Org Chart can support 4 different conditional format rules in addtion to the six "quick format rules" described here.


In this example the page developer has created an organisation chart and is coloring some of the boxes green using the Quick Formatting rules. In addition this chart includes a vacant postition ( circled in red ). The vacant position does not have name and does not stand out from the other occupied roles.

Enter Edit mode & Set First Conditional Format Rule

The page developer switches the page into Edit Mode and opens the Conditional Format Rule 1 property section then sets the first conditional rule to trigger if the RoleType is EqualTo the value Vacant.

These rules are defined in the same way as the Quick Format rules which are explained further here

Apply Rule

Once the Apply button is pressed the vacant position is displayed with a red background

Set HTML Template property

Although the box is red it is still not right. As the role is vacant there is no image to display and the page developer would like to create a method of allowing his customers to apply for the role should they wish.

To do this the HTML Template property is set. This takes HTML markup and uses the value substitution features of the SharePoint Org Chart.

Wrapping a field name in { } tells the SharePoint Org Chart to insert the value of that field into the box.

For more on the substitution syntax seeĀ Custom Templates User Guide.

Apply changes

Once the Apply button is pressed the vacant position is displayed with a red background and a different HTMLTemplate.

Save the chart

Pressing leaving Edit Mode saves the rule and it is applied to the organisation chart. As can be seen in the example the vacant position is now visible and has a hyperlink that allows staff to apply for the role.

How can we help?

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Enter the characters shown in the image.

Our products


  • For Microsoft SharePoint
  • Download, install & configure
  • $750


  • For Office 365 and Microsoft Azure
  • Online, interactive service based application
  • $100 +


  • For ASP.NET websites and applications
  • Versatile & feature rich
  • $200 +

website design & build