Hi,
I am looking for a conditional formatting for this particular sheet which
talk about a staff going on leave (date of leave), the return date is filled
out, now the priority to get the person back on board or not is to be set, if
the comp;any wants him back then if the person doesnt come back on the return
date then the overstay days with higlight colour should reflect on the action
column ie for overstay of 1-15 days green
15 - 30 days orange <30 red

can anyone help me create this.

Thanks.



DATE OF LEAVE RETURN DATE PRIORITY ACTION
YES NO