I have a list to track customer training. Two of the trainig items are recurring; Ethics - annual and GPC Refresher - biannual (every two years). The due dates for each training requirement were created using a calculated column. I would like each cell of those calculated column dates to highlight yellow when they are 30 days out, and highlight red when they are due and past due. I am running SP2013, on-prem, and do not have Designer. I've been able to use a script editor web part to change the font color of certain words in another list that worked great, but highlighting the cell of calculated column dates is over my head. Any help is much appreciated!


1 Answer 1


Calculated columns are updated only when the item itself is updated, so for your indication to be always up-to-date, you'll have to use client-side tricks.

You can adapt ViewMaster. Start from a new calculated field with this formula:

="<img src=""_layouts/images/blank.gif"" onload=""console.log('ViewMaster executed on: " & [Title] & " ');"">"

If you're lucky then Danny Engelman himself will help you :)

  • 1
    That ViewMaster site wil get you started with JavaScript in Calculatd Columns step-by-step Adding color and Today calculations I answered in multiple posts here on SO: sharepoint.stackexchange.com/search?q=user%3A32871+icc+color Commented Mar 7, 2016 at 15:14
  • Thanks for the comments! Aziz, I added your formula to my list; however, nothing happened. Danny, I checked out your other posts, and can't quite figure this out. I'm not a programmer and learned how to use our basic, out-of-the-box, SharePoint through trial and error and YouTube University. I did try your 'Hello World!' button on the View Master site, and it worked, I think. A 'Click Me' button was added to every row of a list; however, when clicked, nothing happened. I think what I'm asking is too complicated for my level of knowledge.
    – raerae
    Commented Mar 8, 2016 at 14:38

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.