Hi guys, can you help me?

I need to combine and IF and insert conditional formatting if possible.

I have a deadline month in A2 and a completion month in B2. C2 is a Status field based on the progress of whether the deadline is < 6 months, > 6 months or >12 months( I currently manually enter in the Status progress whether its "Within Deadline"- (WD), "Beyond Deadline"-(BD) or "Completed".

I want to create an IF statement to do this automatically for me

I would also like some Conditional formatting to colour each status progress automatically ( again I do this manually)


Your help is greatly appreciated
Mike

You can try something like this:
=IF(LEN(B2)>0;"COMPLETED";IF(MONTH(A2)<=6;"WD";IF( AND(MONTH(A2)>6;MONTH(A2)<12);"??";IF(MONTH(A2)>12 ;"BD";"Result if none of the above conditions is met"))))
then, you can use a conditional formatting formula like:
=$C2="WD"