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?