Conditional Column Formatting

Upgrade to Ninja Tables Pro
Upgrade to Ninja Tables Pro and make your tables more powerful

Ninja Tables version 3.0 has come up with some amazing features that will definitely blow your mind. Now, in Ninja Tables, you can format any of the columns of your tables using conditions according to your requirements.

With Ninja Tables’ Conditional Column Formatting feature, you can customize your table appearance based on the cell value of the table. But how can you make this happen?

To make this happen, at first, you have to design a table with some data. For making you understand, I have already created a table named Employee Sheet by retrieving data from Google Sheets using Ninja Tables and I will add some formation to it.

As the table is ready, we can start assigning conditional formatting features in it.

For making this happen, you need to go to the WordPress dashboard, select Ninja Tables from the left sidebar and go to Edit option of your Employee Data table.

Now, you can set Conditional Formatting in two ways. Either you can set it through editing any column one by one in the Table Configuration menu,

One by One Table Configuration

Or you can do it from Table Rows by hovering over any column name and clicking on the Edit icon.

Then, you will see that a pop-up window will show with multiple dynamic options. Go to Conditional Formatting from the top bar.

By default it will show the Basic Settings but you need to click on Conditional Formatting option.

Next, click on Conditional Formatting, then, you will find the necessary options for that particular option. By default, there will have no data and to give condition click on Add Condition button.

Right now it has one conditional field but you can add more conditions by just clicking Add Condition button.

Let’s set conditions as Equal, Not Equal, Contains, Doesn’t Contain in multiple ways. Next, you need to put some trigger values for which conditions will be applied and then set options.

You can choose Cell Options, Row Options, and Column Options too. Then, put new values that will be shown after conditions are applied. In the value section always put the value that matches with the respective row and column.

You also can delete conditions you have just set by clicking the Subtract Button(-)  shown on the right side of each condition of the popup window.

For instance, I am showing you how can you put the conditions. Here, I want to show a specific background colour of the Semon and Martin in the Name row and I want to change the text colour of Sovia as well.

To make this happen, let’s see the following configuration using Conditional Formatting.

After configuring in such way, update the setting and preview it if necessary. The output of the above configuration is showing in the below. Please, have a look at the snap below.

That’s how you can set up Conditional Column Formatting with Ninja Tables.

Upgrade to Ninja Tables Pro
Upgrade to Ninja Tables Pro and make your tables more powerful

Was this article helpful to you?

11 3

How can we help?

Please submit a support ticket if you have any question or pre-sale questions. Our Customer support engineers will answer your query as soon as possible

Open a support ticket