Conditional Formatting with multiple conditions

Dear Team-
First of all thanks to all of your help and assistance in solving the queries in MSO, i m a regular student of this forum,but was an outsider. Now i had joined your Forum.thanks for accepting me
Coming to the business.
My requirement is on Conditional formatting...please find the attachment..hope the attached file would understand my requirement..
anyways the conditions are below;
1.A project starting is greater than 15 days ie from today and less than 30 days, it should format the "Staffing status" color to GREEN,
2.If a project starting is less than 15 days and the staffing status is Open , the Staffing status cell "Open" should be RED
3.IF a project start is less than 7 days from today and Staffing status is RR raised , the cell should be YELLOW
4.If project is less than 1 day and staffing status is RR raised , the cell color should format as RED..

WOudl require ur help on solving this.. please let me know for more information..

Hey matt, thanks a ton!. i m happy to see your response..will try and let you know..thanks again!!

Hi matt.nicolai, I ve tried, but there is some changes with my requirement for which i need your assistance. Here is the updated conditions which is attached in the spreadsheet also is below. Thanks in Advance!!

A]For "Staffing Status":
a)If exp start date is >15 days & <30 days also status = Active/Active Staffing Request/Active Awaiting Paperwork,color GREEN
b)If exp start date is <7 days & Status = Active, color GREEN
c)If exp start date is 7 days & <15days also Status = ASR/AAP = Active, color it YELLOW
d)If exp start date is <7 days & Status = ASR/AAP, color it YELLOW
f)If exp start date <1 day & status = ASR/AAP, color it RED
B]For "Contract Status":
a)If exp start date is >15 days & <30 days also status = PIP not initiated/ Signature Pending/ POPending/POIssued,color GREEN
b)If exp start date is >7days & <15days also Status =PO Pending, color GREEN
c)If exp start date is > 1 day & <7 days also status = PO Issued, color GREEN
d)If exp start date is >7days & <15days also Status = PIP not initiated/ Signatur Pending, color YELLOW
e)If exp start date is > 1 day & <7 days also status = PO Pending, color YELLOW
f)If exp start date is >1days & <7days also Status = PIP Not initiated/Signature Pending, color RED
g)If exp start date is > 1 day & status = PO Pending/ PIP Not Initiated, color RED
C]For "Staffing Status":
a)If exp start date is <15 days & <30days also Status is Started/Submitted/Completed, color GREEN
b)If exp start date is <7 days & Status is Completed, color GREEN
c)If exp start date is >15 days & <30 days also Status is Open/Not Created/Rejected, color YELLOW
d)If exp start date is <7 days & Status is RR raised, color YELLOW
e)If exp start date is <1 day & status is RR raised, color RED
f)If exp start date is <7 days & Status is Started/SM Rejected, color RED

THis thread is not yet resolved. please help..