How to configure Conditional Formatting in SharePoint Designer
How to configure Conditional Formatting in SharePoint Designer
One of the best ways to enhance the user experience is to highlight something about the data they are interacting with. One of the coolest tools available out-of-the-box with SharePoint is Conditional Formatting. With Conditional Formatting, you can designate some condition that the data is in and based on the matching the data values to that rule set. Then you can have SharePoint Style the data in a particular way to have it stand out from the other data on the page.
In this blog, I will take a list of products and using conditional formatting, I will format those products which are under $10 to style the retail price column of those items in a larger font which will be bold and red in color.
To do this, I have created a new Site Collection with the top level site based on the Team Site template (STS#0). I have created a list template with some products inside of it. The list has 3 list columns, the out-of-the-box title column which I changed to sku, ProductDescription is multi lines of text and retailPrice which is currency. I based the list on the Custom List Template. I added some products to the list before saving it as a template with a variety of prices including a few that are below $10.
Here are the steps I will go through in the blog:
- Create a list based on my custom template
- Open SharePoint Designer
- Create a new aspx page called ProductsPage.aspx
- Connect the page to the V4.master page.
- Create custom content inside the contentPlaceHolderMain
- Insert a Data View of the Products List
- Add Conditional Formatting to the Web Part
- Set the ProductsPage.aspx as the home page of my site.
- Add a filter to only show the products under $10
- Customize the Sorting of the remaining items to be Ascending
- Adjust the visible columns to just show the ProductDescription and RetailPrice.







































Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ
You May Also Like
conditional formatting, shared documents, sharepoint designer 2010, web parts
A Simple Introduction to Cisco CML2
0 3703 0Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2
Cable Testers and How to Use them in Network Environments
0 668 1This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments
Configuring Windows Mobility Center and How to Turn it On and Off
1 1413 1Video transcription Steve Fullmer: In our Windows training courses, we often share information about the Windows 8.1 Mobility Center. Mobility Center was introduced for mobile and laptop devices in Windows 7. It’s present and somewhat enhanced in Windows 8. Since we don’t have mobile devices in our classrooms, I decided to take a little bit … Continue reading Configuring Windows Mobility Center and How to Turn it On and Off
See what people are saying...