highlight cells based on how big or small the number in the cell is

  • Resolved Randika

    (@harunstudio)


    2 years, 8 months ago

    Hi Tobias,

    First of all, I say a thousand thanks for creating this very useful plugin.

    I’ve been playing around with TablePress a lot, made over 50 tables so far and I really like it.

    I want to ask about how to give a certain color (specific) to the number in the cell, based on the size of the number.

    As an example:
    – more than 99.90% will be green
    – less than 99.90% will be red

    or
    – more than 500 will be red
    – less than 500 will be green`

    • This topic was modified 2 years, 8 months ago by Randika. Reason: grammar errors

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    While I can think of a method to highlight a cell if it exactly matches a value, I’m not aware of a solution to this, where “greater than” or “smaller than” comparisons are needed ?? I’ll add this to my list of ideas, maybe I can come up with a solution in the future. Sorry for not having better news here.

    Regards,
    Tobias

    Thread Starter Randika

    (@harunstudio)

    Hi,

    No problem. Thanks for adding it to your list of ideas.
    I thought about using a method like this:

    Inside the cell, I’ll use this code for example:
    <span class=”green”>500</span>

    And the CSS code:
    .green {color: green}

    What do you think? is the method above the most effective or is the method using highlight cell extensions better in terms of performance?

    Kind regards,
    Willya

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    this is indeed the best manual method. The Highlight Cells Extension can help automate this — with the mentioned exact comparisons, but not “greater/smaller than” checks, for which you would need the manual method.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘highlight cells based on how big or small the number in the cell is’ is closed to new replies.