I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built in features.
Conditional formatting in our plugin is used only for one column, and cannot connect two or more columns in a condition.
There's probably a way of doing this with some custom code in SQL, or JS, but please note that support covers help with bugs and questions, but not writing custom code.
I need to format a column based on information in two other column like an if,then formula in Excel. Example:
If the value in column 2 is equal to the value in column 3 then the value displayed in column 4 should = "2".
Hello CoastPro.
Thank you for your purchase.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built in features.
Conditional formatting in our plugin is used only for one column, and cannot connect two or more columns in a condition.
There's probably a way of doing this with some custom code in SQL, or JS, but please note that support covers help with bugs and questions, but not writing custom code.
Sorry for any inconvenience.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables