Reply To: Conditional Format of column??

Forums vLooup for SharePoint Conditional Format of column?? Reply To: Conditional Format of column??

#9573

Alexander Bautz
Keymaster

Hi,
Use a custom function like this.

1. Add “Special configurations” to the field in vLookup setup – see the attachment “ConditionalFormattingDate_1”.
2. Add function to the Justom JS:

function conditionalFormattingDate(a,b){
	var today = new Date(), cDate = b.get_item("Date"); // Date is my date columns fieldinternalname
	if(cDate < today){
		a = "<span style='color:red;'>"+a+"</span>";
	}
	return a;
}

The end result should look like the attached image “ConditionalFormattingDate_2”.