Conditional Formatting

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?