Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-25 Thread Yahya Muhammad
n, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Yahya Muhammad > *To:* excel-macros@googlegroups.com > *Sent:* Thu, October 25, 2012 4:00:10 AM > > *Subject:* Re: $$Excel-Macros$$ Highlight annual leave schedule of each > staff for easy comparison >

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-25 Thread Paul Schreiner
er you can.” - John Wesley >------------- > > > > > ____ From: Paul Schreiner >To: excel-macros@googlegroups.com >Sent: Wed, October 24, 2012 7:49:35 AM >Subject: Re: $$Excel-Macros$$ Highlight annual leave schedule o

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-25 Thread Yahya Muhammad
ong as ever you can.” - John Wesley > *----------------- > > > -- > *From:* Paul Schreiner > *To:* excel-macros@googlegroups.com > *Sent:* Wed, October 24, 2012 7:49:35 AM > *Subject:* Re: $$Excel-Macros$$ Highlight annual lea

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-24 Thread Paul Schreiner
9:47 AM Subject: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison Hi experts I want to compile the annual leave schedule of each staff in the department in excel. The idea is to have all the schedule in one work sheet, for easy comparison and to know the leave

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-24 Thread VBA VABZ
Hi Nice work, you can automate it through conditional formating. Rgds//Vabs On Wed, Oct 24, 2012 at 12:49 PM, Yahya Muhammad wrote: > Hi experts > > I want to compile the annual leave schedule of each staff in the > department in excel. The idea is to have all the schedule in one work > sheet,

$$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-24 Thread Yahya Muhammad
Hi experts I want to compile the annual leave schedule of each staff in the department in excel. The idea is to have all the schedule in one work sheet, for easy comparison and to know the leave overlapping,if any, at one glance. Currently I am using the attached sheet, which I think, can be modif