Conditional Formatting with multiple conditions

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