Black Friday Discount 🎁 Get Upto 50% Off NOW

Automatically Highlight Table Cells Based on Input Value in WordPress

  • Select the cell/column/row you want to highlight
  • Set the conditions
  • Save the table
  • Embed the table shortcode to your desired page
how to automatically highlight table cell on input value

Won’t it be great if your online tables could automatically highlight the table cells based on the data input? It could save you a lot of labor and time you’d have otherwise wasted manually seeking to customize the entries according to the cell input value. “Ninja Tables” WordPress table plugin has a “Conditional Formatting” feature just for that.

Let’s say, you are listing the best smartphones that came out this year. And on that list, you’d like to color code the phones based on their price range like this-

  • Highlighting the flagship smartphones with green if their price range is above $800
  • Highlighting the midrange smartphones with orange if their price range is between $350-$800
  • The budget phones can be color-coded yellow if they cost between $250-$349
  • Leaving the phones below $249 without any special treatment on your online table.

Now, who in their right mind would volunteer to color-code the categories one by one manually if there are more than 20 phones listed on that table?

Well, that’s where Ninja Tables Conditional Formatting comes in! Today I’ll show you how you can customize your tables automatically, and never have to repeat the mundane tasks again. 

Ninja Tables special discount wpmanageninja

Conditional Formatting: the amazing feature you are missing out!

If you are using the free version of Ninja Tables, I can confidently say – “Conditional Formatting” is one of the amazing pro features you are truly missing out on. Depending on the cell value of the table, you can easily match your need and select specific cells or columns you want to highlight in your table. Check this screenshot, for example.

highlighted table using ninja tables conditional formatting feature
A highlighted table using conditional formatting

Benefits of Conditional Formatting 

Imagine you have a huge data table with lots of information. Now you want to highlight some cells or whole rows/columns on your table. What you will do? Manually highlighting the exact cells or columns will be time-consuming and tiresome if you have a large data table. Here comes our pro feature “Conditional Formatting”.

With this feature, you can select your column and set the condition you like- 

  • Equal 
  • Not Equal 
  • Contains
  • Does not Contain

Then set some trigger values and the option for which condition you need to apply. 

conditional formatting option
Conditional formatting feature

How to highlight table cells using Ninja Tables’ Conditional Formatting

Now let me show you how to use conditional formatting to highlight the cells or columns as per your need. You will need a table with lots of data in it. Or you can use an existing table from your Ninja Tables dashboard. Here, we’ll be automatically customizing an employee information table for example.

employee data table editor in Ninja Tables
An example table

Now in this table, let’s highlight some employees under age 25. How do you do it? In Ninja Tables, if your column data type is “Numeric Value” or “Date Field”, you get extra cell values to select from other than the default options. 

These extra options are- 

  • Less Than, Greater Than
  • Less Than or Equal To
  • Greater Than or Equal To
  • Between (Max or Min Value)

We will apply these conditions in our age column. There are two ways you can set conditional formatting. You can hover the mouse over a column and click the settings icon, or you can click “Table Configuration” from the top panel. Both will open an “Edit Table Column” option. 

Ninja Tables editor dashboard

From that click “Conditional Formatting”. You will have to click the “Add Condition” button if you want to add various conditions. You can add as many conditions for a single column. 

how to customize cell highlight based on cell values in ninja tables

For our Age column, we will select the If cell value “Less Than or Equal To” because we want to highlight employees under age 25. Now Add 25 as trigger value. The next box has several options you can apply as your condition. 

set conditions to highlight a table cell in ninja tables

Cell options

  • Set cell color
  • Background color
  • Content
  • CSS class
  • Reset cell color to default
  • Reset cell background color to default
  • Remove cell CSS class

Row options

  • Set row color
  • Row background color
  • Row CSS class
  • Reset row color to default
  • Reset row background color to default
  • Remove row CSS class

Column options

  • Set column color
  • Column background color
  • Add column CSS class
  • Remove column CSS class

In our example, we will select “Set cell background color” and select the color red. Click update. Now click preview to see the updated table. You will see it worked. Employees under age 25 are now highlighted in red.  

Highlight table cells using ninja tables conditional formatting
Highlighted Cell

Now you can add as many conditions as you want here. Let’s use the three corresponding conditions below as examples. 

  • Contains “Senior Executive” in the Designation column – Yellow
  • Does not contain “Male” for the Gender column – Blue
  • Salary Less than or Equal to 20000 – Green

Here you can see below, all conditions are working fine in preview mode. 

highlighted table cells based on input  values in ninja tables
Final highlighted table

We can now embed the final table in our WordPress post or page using Ninja Tables shortcode. Just copy the shortcode and paste it in your post’s desired area. It will show up in your published post.

You can always update your table whenever you want using the edit table option. The changes will automatically appear in your blog post’s embedded table. 

Using the Conditional Formatting feature you can design your table any way you want. Dive into our documentation to learn more ways you can play with “Conditional Formatting”. 

Conclusion

“Conditional Formatting” is one of the most used features of Ninja Tables. I highly recommend trying this Ninja Tables pro feature, you will instantly fall in love with the feature if you are constantly managing large amounts of information in WordPress data tables. Without any coding knowledge, you can easily highlight the cells, rows, and columns of your data table. 

Thank you for taking the time to read this short tutorial. Let us know in the comment if you have any confusion. 
Don’t forget, we are running a limited-time 30% EID special discount on our major products including Ninja Tables! Grab Ninja Tables at a 30% discount from our regular price and use more awesome features like “Conditional Formatting” to make your data tables smart, efficient, and beautiful.

Ninja Tables special discount wpmanageninja

Don’t forget to subscribe to our YouTube channel to get WordPress-related tips and tricks. Also, follow us on Twitter and Facebook.

Nishat Shahriyar

Nishat Shahriyar A.K.A "Nish" is a Writer and Digital Marketer. The vast majority of his interests relate to technology and the creator economy, as well as the WordPress community. He is a profound reader. Nish loves meeting new people, learning about new things, and discussing new ideas. He loves to spend time with his family when he is not writing or working.

Leave a Reply

Subscribe To Get

Tips, Tricks, Update & Inspiration