Tips for updating the color of table data when the value exceeds 0

Question

Tips for updating the color of table data when the value exceeds 0

I'm currently working on developing a transaction table that is intended to display debit values in red and credit values in green. However, I would like these colors to only be applied if the value in the table data is greater than 0 via JavaScript. Can someone please assist me with this?

    <table class="table table-bordered table-striped">
          <thead>
            <tr bgcolor="#ccccff">

              <th scope="col">   Debit</th>
              <th scope="col"> Credit</th>

            </tr>
          </thead>
          <tbody>
            <tr>

              <td id='red' style="color:red; font-weight: bold;"> 100  </td>
              <td id='green' style="color:green; font-weight: bold;">       
                200
                </td>

            </tr>


          </tbody>

javascript html css

Answer 1

Answer №1

After reviewing your HTML code, it appears that you are utilizing datatables which indicates the use of jQuery. Here is a suggested approach:

$(document).ready(function() {
  var table = $('#example').DataTable({
    columnDefs: [{
      targets: 3,
      render: function(data, type, row) {
        var color = 'black';
        if (data < 0) {
          color = 'red';
        }
        if (data > 0) {
          color = 'green';
        }
        return '<span style="color:' + color + '">' + data + '</span>';
      }
    }]
  });
});

<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">

<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.3.1.min.js"></script>

<script type="text/javascript" language="javascript" src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>


<!DOCTYPE html>
<div class="container">
  <table id="example" class="display nowrap" width="100%">
    <thead>
      <tr>
        <th>Name</th>
        <th>Position</th>
        <th>Office</th>
        <th>Age</th>
        <th>Start date</th>
        <th>Salary</th>
      </tr>
    </thead>

    <tfoot>
      <tr>
        <th>Name</th>
        <th>Position</th>
        <th>Office</th>
        <th>Age</th>
        <th>Start date</th>
        <th>Salary</th>
      </tr>
    </tfoot>

    <tbody>
      <tr>
        <td>Tiger Nixon</td>
        <td>System Architect</td>
        <td>Edinburgh</td>
        <td>61</td>
        <td>2011/04/25</td>
        <td>$3,120</td>
      </tr>
      <tr>
        <td>Garrett Winters</td>
        <td>Director</td>
        <td>Edinburgh</td>
        <td>-3</td>
        <td>2011/07/25</td>
        <td>$5,300</td>
      </tr>
      <tr>
        <td>Ashton Cox</td>
        <td>Technical Author</td>
        <td>San Francisco</td>
        <td>66</td>
        <td>2009/01/12</td>
        <td>$4,800</td>
      </tr>
      <tr>
        <td>Cedric Kelly</td>
        <td>Javascript Developer</td>
        <td>Edinburgh</td>
        <td>22</td>
        <td>2012/03/29</td>
        <td>$3,600</td>
      </tr>
      <tr>
        <td>Jenna Elliott</td>
        <td>Financial Controller</td>
        <td>Edinburgh</td>
        <td>33</td>
        <td>2008/11/28</td>
        <td>$5,300</td>
      </tr>
      <tr>
        <td>Brielle Williamson</td>
        <td>Integration Specialist</td>
        <td>New York</td>
        <td>-61</td>
        <td>2012/12/02</td>
        <td>$4,525</td>
      </tr>
    </tbody>
  </table>
</div>

Answer 2

After reviewing your HTML code, it appears that you are utilizing datatables which indicates the use of jQuery. Here is a suggested approach:

$(document).ready(function() {
  var table = $('#example').DataTable({
    columnDefs: [{
      targets: 3,
      render: function(data, type, row) {
        var color = 'black';
        if (data < 0) {
          color = 'red';
        }
        if (data > 0) {
          color = 'green';
        }
        return '<span style="color:' + color + '">' + data + '</span>';
      }
    }]
  });
});

<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">

<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.3.1.min.js"></script>

<script type="text/javascript" language="javascript" src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>


<!DOCTYPE html>
<div class="container">
  <table id="example" class="display nowrap" width="100%">
    <thead>
      <tr>
        <th>Name</th>
        <th>Position</th>
        <th>Office</th>
        <th>Age</th>
        <th>Start date</th>
        <th>Salary</th>
      </tr>
    </thead>

    <tfoot>
      <tr>
        <th>Name</th>
        <th>Position</th>
        <th>Office</th>
        <th>Age</th>
        <th>Start date</th>
        <th>Salary</th>
      </tr>
    </tfoot>

    <tbody>
      <tr>
        <td>Tiger Nixon</td>
        <td>System Architect</td>
        <td>Edinburgh</td>
        <td>61</td>
        <td>2011/04/25</td>
        <td>$3,120</td>
      </tr>
      <tr>
        <td>Garrett Winters</td>
        <td>Director</td>
        <td>Edinburgh</td>
        <td>-3</td>
        <td>2011/07/25</td>
        <td>$5,300</td>
      </tr>
      <tr>
        <td>Ashton Cox</td>
        <td>Technical Author</td>
        <td>San Francisco</td>
        <td>66</td>
        <td>2009/01/12</td>
        <td>$4,800</td>
      </tr>
      <tr>
        <td>Cedric Kelly</td>
        <td>Javascript Developer</td>
        <td>Edinburgh</td>
        <td>22</td>
        <td>2012/03/29</td>
        <td>$3,600</td>
      </tr>
      <tr>
        <td>Jenna Elliott</td>
        <td>Financial Controller</td>
        <td>Edinburgh</td>
        <td>33</td>
        <td>2008/11/28</td>
        <td>$5,300</td>
      </tr>
      <tr>
        <td>Brielle Williamson</td>
        <td>Integration Specialist</td>
        <td>New York</td>
        <td>-61</td>
        <td>2012/12/02</td>
        <td>$4,525</td>
      </tr>
    </tbody>
  </table>
</div>

Tips for updating the color of table data when the value exceeds 0

Answer №1

Similar questions

Discover the best method for transferring MySQL data between pages

Is there a way to display a foundation.css drop-down menu using jQuery?

Tips for incorporating local storage into Angular applications

placing a vertical bootstrap button along the left border

Regular expressions can be used to extract specific attributes and inner content from a div element within a contentEditable container

Urgent concern: the require function is being utilized in a manner that prevents the static extraction of dependencies [mysterious]

What is the proper way to display the date and time 2021-11-14T18:30:00.000+00:00?

- Determine if a div element is already using the Tooltipster plugin

I am attempting to input the form data, but all I see on the console is "null" being printed

Ways to modify the screen when a click event occurs

The process of sending parameters to an API in ReactJS: a guide

What is the best way to move information from one table to a different one?

Using async/await in an Express route handler

The Journey of React Native Routing

Transfer a JSON object to a Java Class without relying on a servlet

Seeking assistance with transferring jQuery to regular JavaScript and installing on the home screen of an Apple device

Strategies for handling asynchronous requests and effectively presenting the retrieved data

Encountering an issue with the vue webpack-simple template: Uncaught TypeError - the intermediate value is not recognized as a function

The integration of CSS into an HTML file is ineffective

Tips for concealing the Bottom bar action in React Native