I can make a JS call to determine whether the value of the closeRateCell is less than the value in the corresponding (hidden) closeRateGoalCell. Based on the response, I assign a class to the cell and write the custom CSS to change the text color.
NOW my problem is the CSS.
I enter the table I am using and choose Customize > Custom CSS. Then I enter the updated CSS.
Some CSS works. For instance, if I say, "display: none !important", the cell/column will no longer display.
The CSS I NEED to work does not. For instance, if I say, "color: #00FF00 !important", nothing happens.
Sorry to disappoint you, but we don't have a built-in way to set up a single Conditional Rule that can check or affect multiple cells or work across multiple columns.
Each conditional rule in our Conditional Formatting feature applies row by row and can only evaluate cells within the same column where the rule is created.
2. Making conditional rule on hidden columns : This is also not possible at this time.
The Conditional Rule is only able to 'see' visible cells. For any cell which is not visible, the rule is not going to 'trigger' any style or any other functionality you created for it.
You can suggest it to our developers, though - they will do their best to make a solution in the future.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
Awesome! I’m delighted to hear this was helpful—thank you for letting me know! :)
You're very welcome.
Please don’t hesitate to reach out again if anything else comes up.
You can also try out our new support system directly on our site. The chat box is located at the bottom right corner. Just note that it is not a live chat, but we do our best to respond as quickly as possible. :)
I need to change the color of text in one column based on whether it is greater than or less than a value in another column.
How do I do that?
I believe I have this partially figured out.
I can make a JS call to determine whether the value of the closeRateCell is less than the value in the corresponding (hidden) closeRateGoalCell. Based on the response, I assign a class to the cell and write the custom CSS to change the text color.
NOW my problem is the CSS.
I enter the table I am using and choose Customize > Custom CSS. Then I enter the updated CSS.
Some CSS works. For instance, if I say, "display: none !important", the cell/column will no longer display.
The CSS I NEED to work does not. For instance, if I say, "color: #00FF00 !important", nothing happens.
What do I do to fix that?
Please help! I really need to get this working.
Hello,
Sorry to disappoint you, but we don't have a built-in way to set up a single Conditional Rule that can check or affect multiple cells or work across multiple columns.
Each conditional rule in our Conditional Formatting feature applies row by row and can only evaluate cells within the same column where the rule is created.
2. Making conditional rule on hidden columns :
This is also not possible at this time.
The Conditional Rule is only able to 'see' visible cells. For any cell which is not visible, the rule is not going to 'trigger' any style or any other functionality you created for it.
You can suggest it to our developers, though - they will do their best to make a solution in the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
We also added this new developer's handbook, which can allow users with coding skills to make custom add-ons.
Our developers will keep adding more custom hooks/examples there over time.
-
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thank you. I was able to go in and use a mixture of JavaScript and CSS to achieve my goal.
Hello,
Awesome! I’m delighted to hear this was helpful—thank you for letting me know! :)
You're very welcome.
Please don’t hesitate to reach out again if anything else comes up.
You can also try out our new support system directly on our site. The chat box is located at the bottom right corner. Just note that it is not a live chat, but we do our best to respond as quickly as possible. :)
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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