Hi all,
I’m new here, so please be nice.
I have an issue and cannot for the life of me see the proper way of programming it.
It is a simple case of conditional formatting, which I have done hundreds of times. But this time, I’m struggling.
Here’s the scoop:
In SP 2010 using SPD, I have a list that I would like to be able to conditionally format based on Renewal Date.
Here’s the conditions:
1. If @RenewalDate >= [Today]+61 then background = green
2. if @renewaldate <= [Today]+60 and @renewaldate > 30 and @paid != ‘Yes’ then background = yellow
3. if @renewaldate <=[today]+30 and @paid != ‘Yes’ then background = red
4. if @renewaldate = [today] and @paid != ‘Yes’ then background = grey
What is killing me is the +61 days, +60 days, and the +30 days parts of the equations.
Can someone point me in the right direction?
Yes, you can. But I would need to create a calculated column for each of those conditions. Which I can do, I was just hoping there was another way
Can’t you create another Calculated column in SharePoint (remove it from the default view), user formula as =[RenewalDate]+61
Based on that condition, change the background color
