Highlighting a row in color

[rnk4f]

I have an employee database in which I have to highlight all the leavers/serving notice in red color & current month joiners in green color without manual effort. Is there any formula to do it? Or conditional formatting shortcut available?

Untitled.png

Hope the attachment explains the query clearly. When there is a leaving date mentioned that particular row should change to red.
When there is a new joiner current month that particular row should change to green.

[AliGW]

Yes, but we would need to know the logic. I guess for the leavers, its a date in DOL, but how do we identify joiners? How long do they need to be flagged as new?

[rnk4f]

Leavers to be highlighted in the red color permanently based on DOL.
Joiners can be identified by the date in DOJ and they should be highlighted in green only for that particular month. Next month, that month joiners & so on.

[AliGW]

OK. Two ticks!

[AliGW]

Joiners:

=AND(MONTH($D1)=MONTH(TODAY()),YEAR($D1)=YEAR(TODAY()))

Leavers:

=$E1<>""

Both applied to the entire range.

[rnk4f]

Please help with the steps to apply this formulas. I am quite unsure of where to apply.
Sorry if this looks silly, I have just started learning excel formulas.

[AliGW]

Post your file here, please.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[rnk4f]

Attached the document.

[AliGW]

See the attached - select any cell in the table range and then open the conditional formatting dialog to see the rules and how they are set up.

[rnk4f]

Thanks a lot

[AliGW]

You're welcome!