conditional formatting a column in view


  • Hi,

    I have a task list with Alltasks.aspx view.

    I want to color a column based on a condition in the above view.. I succeeeded in doing that on a row level using SPD but not for a specific column

    I've tried utiizing the conditional formatting in SPD once i entered the desired column but no luck.

    Any thoughts?

    Thanks a lot in advance

    Thursday, August 01, 2013 10:42 AM


  • Hi,

    Please use the following formula, there is something wrong with HTML

    =CONCATENATE("<div class='convertToHTML'><img src='/pwa/customisation/images/RAG",[RAG],"Sml.gif'"," alt='",[RAG],"' title='",[RAG],"'></div>")

    Two things you have to note

    • Give correct image URL path, where you have uploaded the images
    • Run the following JQuery Code to convert div tag to Image
     function listViewCalcColChangeToHTML() {
        $('table[class=ms-listviewtable]').find('td:contains("convertToHTML")').each(function() {

    **Please mark as answered and helpful

    Recently Published Gallery, please rate and download
    PowerShell Script for Creating Site Collection with Host Headers

    • Marked as answer by arevach Wednesday, August 07, 2013 10:25 AM
    Tuesday, August 06, 2013 4:46 PM
  • Hi

    check this post , where i explained aboud  column conditional formatting based on specific values

    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    • Marked as answer by arevach Wednesday, August 07, 2013 10:25 AM
    Wednesday, August 07, 2013 7:24 AM

All replies