Hi
As most people probably know the option for conditional formatting is no longer available in SharePoint Designer 2013. I was looking at some JavaScript and JQuery examples and found this:
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js” type=”text/javascript”></script><script>
   $(document).ready(function(){
     $Text = $(“td .ms-vb2:contains(‘Bristol’)”).filter(function() {
     return $(this).text() == “Bristol”;})
     $Text.parent().css(“background-color”, “#00FF66”);
     $Text = $(“td .ms-vb2:contains(‘Thames’)”);
     $Text.parent().css(“background-color”, “#FFFF66”);Â
    }); </script>
In this example and the  examples I find, it seem to be checking the entire list for a value and not searching for the value in a particular column. Being very new to JavaScript or JQuery is there a way I can alter this to search on a particular column.
You can also mix in Javascript in a Calculated Column (as explained on http://viewmaster365.com/#/How)
Then you can easily add more Towns and color the whole Row:
=[Town]
&”<img src=””/_layouts/images/blank.gif”” onload=””{“
&”this.parentNode.parentNode.parentNode.style.backgroundColor=“
&”({‘Bristol’:’Yellow’,’Thames’:’Green’,’London’:’Pink’})[‘“
&[Town]
&”‘];“
&”}””>”
Be aware debugging Formulas is a real PITA in SharePoint;
CalcMaster
When you add one JS file to your SharePoint environment and have it called with a Bookmarklet (Button on you Browser Favourites bar) this GitHub code will attach itself to the textarea when editting a Formula and provide immediate feedback on errors.
