conditional formatting help needed

[cinnamorolls]

hi, i need help for the attached excel file.
i wish to do some conditional formatting. my target for the first 6 months from date activated is 50,000 after 6 months is 100,000. and for those below target, i will need it to be highlighted in red. thus i have 2 sets of conditions.(calculate the no. of months and the revenue). thanks in advance

[gak67]

Book2.xlsx
I have done the two conditional formats different colours so you can see the difference, but you can change to suit your needs.

[cinnamorolls]

Dear gak67,

many thanks for your prompt help!!! i can submit my work to my supervisor!!