Highlight row in SharePoint list using Calculated Field

Using calculated column to write html has been well known since SharePoint 2007. I always like to do this because it does not require complex customization on xslt or even SharePoint designer. Today I check out this blog which has more good examples: http://sharepointwijzer.nl/sharepoint-blog/tech/icc-html-calculated-column-sharepoint-view/#ICCadvanced

I would like to share a simple solution to highlight rows in SharePoint list using calculated field.

highlight

Calculated formula:

=IF([YesNo],"<img src='/_layouts/images/blank.gif' onload='javascript:{this.parentNode.parentNode.parentNode.style.backgroundColor=""Yellow"";}'>","")

Simple. Hope this save the time many out there seeking for quick solution.

Leave a Reply

Your email address will not be published. Required fields are marked *