An Introduction to Conditional Formatting

Links (11/11/2007) « Steve Pietrek’s SharePoint Stuff

Links (11/11/2007) « Steve Pietrek’s SharePoint Stuff — Mon, 12 Nov 2007 04:17:42 GMT

PingBack from http://stevepietrekweblog.wordpress.com/2007/11/11/links-11112007/

Bedingte Formatierung im SharePoint Designer

SharePoint, SharePoint and stuff — Mon, 12 Nov 2007 12:52:50 GMT

Ein kurze Einführung in die bedingte Formatierung eines DataViewWebparts mit Sharepoint Designer gibt

WSS 3.0 & MOSS: Recopilación de enlaces interesantes (X)!

Blog del CIIN — Wed, 14 Nov 2007 10:21:17 GMT

De nuevo os presentamos la tradicional entrega de enlaces interesantes que sobre WSS 3.0 & MOSS han

re: An Introduction to Conditional Formatting

pc — Mon, 19 Nov 2007 22:06:40 GMT

I wanted to ask your team a question but didn't know where to send it so I'll leave it here.

I have a custom form with several list form fields. The default size of the list boxes is 143px X 125px. This is not large enough to display the entire list item, and I would like to make it larger. I was able to increase the sizes of the single and multiple line text boxes by modifying the core.css. However, I can't find where to increase the size of the list boxes. Can you help?

re: An Introduction to Conditional Formatting

kraabe@golder.com — Tue, 20 Nov 2007 04:33:05 GMT

Can conditional formatting be applied to other types of views, or only data views? Our users are looking for the ability to color code their calendars based on where team members will be. I have set up the calendar list to include a case limiting field, but can't apply the conditional formatting to an OOB calendar view. Suggestions?

re: An Introduction to Conditional Formatting

Jon Campbell — Wed, 21 Nov 2007 11:01:49 GMT

kraabe - The conditional formatting features discussed in this post are tied to dataviews, since they are implemented using XSL. You could construct a calendar view by hand using xslt and then use conditional formatting, but as far as I know you cannot use conditional formatting with the ListViewWebPart (which is what the OOB calendar view uses).

re: An Introduction to Conditional Formatting

Paula — Tue, 04 Dec 2007 17:14:48 GMT

Hi john

I'm having a problem on my datalist view web part.

I have a date time column and I’ve already format the cells to appear dd-mm-yyyy, the problem is on my filter...it appear like date + time ( ex: 1/1/1990 12:AM).

How can I retrieve only the date excluding time from here? Can you help me? thks!!

re: An Introduction to Conditional Formatting

JLT-DSI — Thu, 03 Jan 2008 20:37:36 GMT

Thank you for the helpful post.

Do you know how to conditionally "Apply a Class" instead of specifying the individual style elements (i.e. "Apply a Style")? The default data view applies a CSS class (.ms-alternating) for alternating rows, but I don't see any way to create a new formatting rule that is class-based (without modifying the XLST of course).

Thanks in advance

re: An Introduction to Conditional Formatting

spdblog — Mon, 07 Jan 2008 19:46:25 GMT

Hi JLT-DSI,

Right click your main toolbar and choose to show the Style Applcation toolbar. This will allow you to make selections as necessary and you can change the settings in the toolbar so you have complete control over whether a new class is created, you use preexisting class, or use inline styling.

If you simply want to modify 'ms-alternating' then you can CONTROL + CLICK the class in code view and modify it by hand. It's not completely clear what you want to do here, but hopefully that toolbar (as well as the CSS Properties Task Pane) will help you on your way.

-John

re: An Introduction to Conditional Formatting

tlhacker — Tue, 18 Mar 2008 19:06:23 GMT

I have very simple query bringing in a few skillsets with multiple competencies per skillset and a rating assigned to each competency. I am grouping on the skillset and displaying KPIs for each competency based on the rating using conditional formatting. That all works great. What I am struggling with is using that same formatting to display an average rating (and KPI) for each skillset, but when I insert my images and set the conditional formatting, it is applied to each group "header". I want to be able to apply different conditional formatting to each skillset in the group. Greatly appreciate any insight.

re: An Introduction to Conditional Formatting

KULDEEP — Mon, 26 May 2008 16:42:44 GMT

Hi Jon,

I have a custom list in which one group title is there and the url for that report is stored. I want to format the report according to the group title when ever a gruop title presents in the list then a system pick the URL from the custom list and put it in the side of the group. The list is another webpart. Can it be possible using conditional formatting?

-KULDEEP

re: An Introduction to Conditional Formatting

Dan — Thu, 29 May 2008 14:13:31 GMT

I'm trying to use things with conditional formating with Approval Status to determine if I should put a big DRAFT on the Custsom List form. I've used the set it up, but for some reason it never properly evaluates the items status appropriately. I've got several other conditional formats setup of the form successfully, but this one doesn't work. Any thougths? Thanks.

re: An Introduction to Conditional Formatting

Jon Campbell — Fri, 13 Jun 2008 02:48:54 GMT

Dan - One trick that I use a lot when doing conditional formatting is to change one of the values in my view to be one that you are interested in. One way is to put <xsl:value-of select="@_ModerationStatus"/> inside the <xsl:template name="dvt_1.rowview"> in a place that would render properly, such as beside the <xsl:value-of select="@Title" />. Another easy way is to select a value from your list (like the title), then do Edit -> Quick tag editor. Replace the @Title with @_ModerationStatus.

When you view the page you should see the values that the value you care about is getting. I tried it on a blog and ended up with "Approved" as the value for posts which were approved and "Pending" for draft posts. you could do a @_ModerationStatus = 'Pending' and it should do the job.

re: An Introduction to Conditional Formatting

krystie — Sat, 13 Sep 2008 11:53:31 GMT

Hi, thanks for your post. I'm having issues with conditional formatting. Conditions that aren't in the range I have specified are showing up highlighted, It is a student results database - here is an example:

<xsl:if test="normalize-space(@AssessmentType) = 'On Demand - Reading' or normalize-space(@AssessmentType) = 'On Demand - Maths' and normalize-space(@YearLevel) = 'Year 4' and normalize-space(@Semester) = '2' and @Result > '3.0'">background-color: #CCFFFF;</xsl:if>

But even though the result is not greater than 3, I am getting the specified highlighting.

I have checked all my conditions and the code, and the only thing I can associate is that the columns that are giving misleading formatting are those that have been EDITED. Does Sharepoint remember the conditional formatting of the initially created item and never change? I have even tried deleting the entry altogether and re-entering it, but it seems to have a very good memory! It still associates the original conditional formatting of the item in that position in the list... very strange indeed!! Hope you can help!

re: An Introduction to Conditional Formatting

krystie — Sat, 13 Sep 2008 16:52:34 GMT

Please disregard my silly question earlier - I've worked out it's my error in using the OR statement in the condition. I will fix it up and do the two assessment types as two separate conditions. Sorry to waste your time...

re: An Introduction to Conditional Formatting

murali — Thu, 26 Mar 2009 15:34:06 GMT

HI ,

I have requirement like this

I don't want display complete one list item column description value in Data View.

it means if suppose thhat column one item having 3 line of data,but i want display ony only line.

Pls give me advise.

re: An Introduction to Conditional Formatting

fatgorchy — Thu, 23 Jul 2009 06:24:41 GMT

thanks

good introduction to new users