Conditional Format & Vlookup Error!

[fugro]

Hi,

I am trying to create a Holiday Planner for my company. After extensive research and learning i have gotten so close to finishing but I am getting an error which means the dates i input are not formatting the requested cells...please see attached.

Info:
JAN JUN Cell I10 was the first formula with conditional formatting...I dragged this across but i get error messages and it wont colour the cells red as i am trying to request.

Dates are taken from Sheet EmployeeData Cells BS4 to BU603. The names are repeated 10 times down this list as people may take more than 1 slot of time in the year...I hope you can make sense of it. I basically did this as I thought it was the only way VLOOKUP would work and now I'm thinking because ive repeated names this is where it is hanging up?

I know i could have used VB but I am still trying to get my head around the basics, so I tried!

Idon't know if this will be a problem but i did creat a macro for a calendar which i short-cut as CTRL-Z (I now have learnt this is undo)

Thank you in advance to any help or ideas you can give!

Regards

Warren