We're displaying all kinds of values in the range of approx -10 to 50, including decimal places. These are essentially performance scores, and we'd like to color code them for visitors using conditional formatting.
However the current rules are pretty restrictive and it's not feasible to include all potential values and 2 digits because we need to reply on if value equals X then... https://prnt.sc/1z6l5p0
Do you plan to update the conditional formatting feature and introduce better rules, e.g. between 1 and 2, between 3 an 4, or if smaller than 5.... so we can encompass all numbers in a broader range instead of having to manually type the value, because that's pretty difficult/impossible to do given the size of our data set.
Lastly, one column in our table is Float - I assume in this case the content of the columns are aligned to the right? How can we align it also to the left like other data types?
While our development team has quite a lot of updates planned for the next two quarters, I don't believe updating Conditional Formatting logic will be included. Please feel free to add this as a feature suggestion on this page.
From what I see on your screenshot, you are trying to apply numerical conditional formatting to a string-type column. That's not going to work in any other way than how you configured it, because strings don't have the same logic as integers or floats. should only apply 3 rules here:
Hello,
We're displaying all kinds of values in the range of approx -10 to 50, including decimal places. These are essentially performance scores, and we'd like to color code them for visitors using conditional formatting.
However the current rules are pretty restrictive and it's not feasible to include all potential values and 2 digits because we need to reply on if value equals X then... https://prnt.sc/1z6l5p0
Do you plan to update the conditional formatting feature and introduce better rules, e.g. between 1 and 2, between 3 an 4, or if smaller than 5.... so we can encompass all numbers in a broader range instead of having to manually type the value, because that's pretty difficult/impossible to do given the size of our data set.
Lastly, one column in our table is Float - I assume in this case the content of the columns are aligned to the right? How can we align it also to the left like other data types?
Thanks
Hello David
Sorry for the late response.
While our development team has quite a lot of updates planned for the next two quarters, I don't believe updating Conditional Formatting logic will be included. Please feel free to add this as a feature suggestion on this page.
From what I see on your screenshot, you are trying to apply numerical conditional formatting to a string-type column. That's not going to work in any other way than how you configured it, because strings don't have the same logic as integers or floats. should only apply 3 rules here:
If cell value > 1 set cell color #F44336
If cell value > 2.5 set cell color #FFC107
If cell value > 4 set cell color #4CAF50
Like this:
And the table would look like this:
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