Hi, this is my first post and I am relatively new to excel so please bare with me. I have a worksheet that has the following information:

Column A Due Date
Column B Status

When column A is within a day of today's date the row (which contains other headings) needs to turn the font Red. At present I have done this via conditional formatting using Formula is 
=A1-TODAY())<2
on it's own this works.

When column B is entered as Finished I want that entire row to turn Green. So I have used conditional formatting using Formula is 
=B1="Finished"
this works in conjunction with condition 1.

However the final part of this is I need every second row to show a blue background colour so the data is easier to read. Again I have added the conditional formatting using Formula is 
=MOD(ROW(),2)
on it's own this works but not as a condition added with the other two.

Can anyone advise me on how I can run these three conditions together? I need every second row blue. If it is past it's due by date the font goes red. If the status is change to Finished the font goes green.

Thank you in advance.