none
How do I apply conditional formatting using SharePoint Designer 2013?

    Question

  • I'm attempting to apply Conditional Formatting to a list view web part via SharePoint Designer 2013, and I can't seem to find the option to do so.

    I've a horrible feeling I'm just being daft, but here's what I've done so far:

    - Created a new page (I've tried both web part and wiki)
    - Added a list "App part" and saved the page
    - Checked-out and opened the page via Designer
    - Clicked the "Edit file" option
    - Selected the XsltListViewWebPart tag

    So far I can't find any options to add it. If I open the Conditional Formatting pane via the View menu it tells me the following:

    > To use conditional formatting, select an HTML tag, data value, or
    > range of text, and then click Create to specify formatting options.

    I've tried selecting the web part tags in all manner of combinations with no luck. In previous version I would have simply selected the previewed data rows in the now-absent Preview pane.

    Am I missing something?


    • Edited by Stuart Pegg Friday, January 11, 2013 7:55 AM
    Friday, January 11, 2013 7:55 AM

Answers

All replies

  • Hi Stuart,

    as I understood, this option is not available "native" in SPD 2013. Theres is no "design-View" anymore.... (http://social.technet.microsoft.com/Forums/en-US/sharepointitpropreview/thread/8f8e2cb3-a90f-4653-9d22-050f9f0d8612)

    When you want to customize the list you have to create manually an xsl-template for this list.

    Also me hope to get some helpful answers here how to customize lists, esp. External BCS-Lists...

    Me I'm not deep in the topic of xsl-Style and formatting and I enyod to this in SPD2010.

    Bernhard

    • Marked as answer by Stuart Pegg Friday, January 11, 2013 8:54 AM
    Friday, January 11, 2013 8:15 AM
  • Thanks, glad to know it's not me! Although unfortunately that link doesn't work.
    Friday, January 11, 2013 8:54 AM
  • Hi Stuart,

    sorry I think during pasting a bracket ")" at the foun it way in the link.. Here again without brackets ;-)

    http://social.technet.microsoft.com/Forums/en-US/sharepointitpropreview/thread/8f8e2cb3-a90f-4653-9d22-050f9f0d8612

    Bernhard

    Friday, January 11, 2013 9:08 AM
  • I have created a blog post with instructions on getting your conditionally formatted DVWP into SharePoint Designer 2013.

    http://www.cdpdev.com/Blog/Post/7/Conditional-Formatting-in-SharePoint-2013


    Chris

    Monday, July 29, 2013 4:45 PM
  • Hi,

    Conditional formatting can be done through XSLT modification of list. Please refer this link for the same:

    http://lmittal.blogspot.in/2014/05/conditional-formatting-in-sharepoint.html


    Lalita Mittal

    Thursday, May 15, 2014 3:32 PM
    1. Create and edit a Wiki Page
    2. Click Inset > Data View and Select “Empty Data View”
    3. Click Inside the <DataSources> tags </DataSources>
    4. Click Insert > Data Source “Your Data Source Name”
    5. Hold down Ctrl button and select the Rows in the order you want them to appear from your “Data Source Details” Window.
    6. After the Rows are selected click on the drop down “Insert Selected Fields as…” at the top of the “Data Source Details” Window.   
    7. Select “Multiple Item View” option (This will create the xsl where we need to add the conditional formatting to)
    8. Find the <tr> tag that contains the Row Data.  Insert the following right below the <tr> tag:

    <xsl:attribute name="style">

    <xsl:if test="@FieldName = 'Something'">background-color: #FF0000;</xsl:if>

    </xsl:attribute>

    I hope this helps.  I figured this out by using the old 2010 Designer to figure out the where to place the code and how to do this.

    Monday, June 23, 2014 6:22 PM
  • List Booster

    There is a SharePoint product that does conditional formatting in lists and document libraries. It also allows to resize columns, change font styles and colors and many more – it is called List Booster. Check it out at http://www.spbooster.com – works in SharePoint 2013 and SharePoint Online.

    Paul Shkurikhin blog.sharepointalist.com


    Saturday, September 19, 2015 3:47 AM