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