Okay
  Public Ticket #2914558
Conditional formatting rules
Closed

Comments

  • David Kanika started the conversation

    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

  •  2,572
    Aleksandar replied

    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:

    9218796314.png

    And the table would look like this:

    6338045201.png


    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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