Reply To: Conditional Format of column??

[Alexander Bautz]

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”.

Attachments:

1. 

   ConditionalFormattingDate_2.png
   

2. 

   ConditionalFormattingDate_1.png