conditional formatting

T

tweety

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
Click to expand...

can anyone help me create this.

Thanks.



DATE OF LEAVE RETURN DATE PRIORITY ACTION
YES NO
 
T

The Code Cage Team

if your Leave date is in A1 and your Return date is in B1 and todays
date in C1 have this in D1 to workout how many days holiday =B1-A1 in E1
have =C1-A1-D1 to show how many days over simply set your conditional
formatting (you can have 3 conditions without using vba in xl2003 more
in xl2007) for that cell. Its a little difficult to get what you mean
really!


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
 
Top