I have a calculated column which returns YES NO. I want to color code the entire row based on these values. Below is my code using CSR

**(function () {
    // Initialize the variable that stores the objects.
    var overrideCtx = {};
    overrideCtx.Templates = {};
    //OnPostRender call postRenderHandler function.
    overrideCtx.OnPostRender = postRenderHandler;

    // Register the template overrides.
function postRenderHandler(ctx) {
    var rows = ctx.ListData.Row;
    for (var i = 0; i < rows.length; i++) {
        var CALOUTPUT = rows[i]["Start of Month"] === "YES";
        if (CALOUTPUT) {
            var rowElementId = GenerateIIDForListItem(ctx, rows[i]);
            var tr = document.getElementById(rowElementId);
            tr.style.backgroundColor = "#ada";


=IF(AND([Due Date]<TODAY(),TODAY()<[0-30days]),"YES","NO")
  • 1
    You can try this type of calculated column formula for color: sharepoint.stackexchange.com/questions/169777/… Commented Jun 17, 2016 at 6:15
  • I think Your code is not working when have a group by set for the view. I removed it and it is working. But if we want Group by then?? Commented Jun 17, 2016 at 6:30
  • It's working in my list even in group by Commented Jun 17, 2016 at 6:52
  • yaa i is working now .. my page was in cache ... thanks for all your help. Commented Jun 17, 2016 at 7:23

2 Answers 2


Try this code

SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() {

     OnPostRender: function(ctx) {

       var calcColors =  {
          'Yes' : '#FFFFFF',  
          'No' : '#FF0000' 

       var rows = ctx.ListData.Row;
       for (var i=0;i<rows.length;i++)
          var calculatedCol = rows[i]["Start of Month"];
          var rowId = GenerateIIDForListItem(ctx, rows[i]);
          var row = document.getElementById(rowId); 
          row.style.backgroundColor = calcColors[calculatedCol];

Related article to CSR :

  • var calculatedCol is geeting undefined when i put alert??. Output of the Calculated column is not geeting using CSR Commented Jun 17, 2016 at 5:53
  • check if debugger mode if rows[i]["Start of Month"] is giving correct value. Make sure your column name is correct, even check for spaces
    – Gaurravs
    Commented Jun 17, 2016 at 5:55
  • My column name is correct it should be display name only right??. I have added the list view webpart in a page and added the JS link over there is this correct Commented Jun 17, 2016 at 6:06
  • Use internal name
    – Gaurravs
    Commented Jun 17, 2016 at 6:07
  • Did it worked ?
    – Gaurravs
    Commented Jun 17, 2016 at 6:27

Your code will only work if you Update ALL Items EVERY day

As explained in: How to use Today and Me in Calculated column

You have to do the Today comparison in the JavaScript code

I whipped this up quick, works on a standard Task List.

function ColorCodeDueDate(ctx) {
  var fieldname=ctx.CurrentFieldSchema.RealFieldName,
      datevalue=new Date(ctx.CurrentItem[fieldname]),
  if (!days) return 'No '+fieldname;
  if (days<5) style="background-color:red;color:white";
  if (days<-30) style="background-color:green;color:white";
  return String.format("<div style='{0}'>{1} days from {2:dd/MM/yyyy}</div>",style,days,datevalue);


  • Use the Chrome Extension Cisar (by Andrei Markeev) to code CSR files.
  • Should be easy to spot how to change it to your 180 days
  • Do not hardcode internal fieldnames; this function can be applied to any DateTime field
  • Try to code with only one exit point (return) in your functions; makes it a lot easier to read
  • GetDaysAfterToday() comes from SharePoints own sp.datetimeutil.js library, but you might have to load it as extra JSLink first; because SP loads it after your CSR code executes
    (OR copy that function code into your own CSR file)
  • String.format() comes from SharePoints msajaxbundle.js; which is loaded before your CSR code executes

With the https://iCSR.github.io Library you do not have to write a function at all

If you declare the View as:

  View : iCSR.DueDate({

You get this: (screenshot from another post)

  • msRed and msGreen are iCSR tokens matching the colors from the new Microsoft Planner
  • iCSR adjusts the textcolor contrast for you (on each cell, you can't set a textcolor on a TR row)
  • and more

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.