Hi,
This site has already helped and I've only just joined.
I am however needing help as I can't find how to do this anywhere.
I am making a work holiday sheet and I have the staff names (21), depts (7), and months (12) all on autofilter. I then have 1-31 days along the top for each month.
I have been asked to put conditional formatting when certain depts all have holidays at the same time. i.e. if i chose the IT dept for April which has 4 staff and they are all wanting the 10th April off can this show up the colour red say.
I have been trying some IF statements but can only do one cell at a time which is no use.
Any help would be greatly appreciated as I have spent all day without any joy.
I was also doing drop down menus for the names, depts and date but this was getting too complicated for one sheet so I went for the autofilter which is pretty easy.
Cheers,
John
Bookmarks