SharePoint Designer 2010 - Conditional Formatting on List

Question

I have been asked to apply conditional formatting to a list in SharePoint 2010 to change the font colour if the difference is 7 or less when you minus the date in the Date Valid column from todays date. So...

Today – Date Valid <= 7

I can apply simple conditions but I think the one I have been asked for would need to be done in the Advanced Condition window and I haven't been able to figure out what it would be.

Does anyone know what the condition would be?

Answer 1

I would suggest making a calculated column called Today - Date Valid and that does your calculations for you. Just hide the column from any view so you don't have this data showing up.

Then go into SharePoint Designer and do your Conditional Formatting where Today - Date Valid is the Field Name, Less Than Or Equal is your Comparison, your Value can be edited be clicking Advanced and putting in 7 (or you can create a new parameter and set its value to 7, not sure if this will work but you can try), and then going and setting your style.

Hope this helps

edit: you can use this for reference https://blogs.msdn.microsoft.com/balsharfi/2011/10/20/sharepoint-lists-conditional-formatting-using-sharepoint-designer-2010/