Tag: Formatting

Not the way that you are selecting cells, because you are using the CSS selector :contains() to find cells with a specific text value. You can’t use contains() for anything other than an exact match.

You could look at ranges if you get the value of the table cells in a usable way in code and then compare it to a range:

// this selects _all_ of the table cells that match your CSS selector,
// regardless of their content, and loops through them all
$("td .ms-vb-lastCell.ms-cellstyle.ms-vb2.ms-vb-lastCell").each(function() {

    // inside the loop function, "$(this)" refers to the single table cell
    // that is getting looped over that time through the loop.  you can use
    // jQuery's "text()" function to get the text contents of the cell 
    var cellText = $(this).text();

    // from your code example, it appears as though you are expecting the
    // contents of the cells to be precentages, i.e "10%", "20%", etc.
    // so you can use parseInt() to change the percentage string into
    // an actual number so you can do number comparisons
    var cellPercentValue = parseInt(cellText);

    // then you can do your comparisons, and set the background color
    // accordingly.  remember "$(this)" still refers to the table cell
    if (cellPercentValue >= 50) {
        $(this).css('background-color', 'green');
    } else if (25 <= cellPercentValue < 50) {
        $(this).css('background-color', 'yellow');
    } else if (cellPercentValue < 25) {
        $(this).css('background-color', 'red');
    }
});