I cant seem to add an attachment. So basically I have across the top I have days, down the left employee names and then under each day hours worked and in this area they currently show hours worked in a colour (or a cell colour) to denote holiday (this is done in Word at the moment so I am trying to move it to Excel - this is a working document ie printed out and shown to staff). So all hours are in the same area, but holiday is just a different colour.
So my view would be if(a1=yellow,a1,maybe a different question)
That then means all hours in that day are holiday whereas I need to split this per employee, ie they aren't all going to be on holiday on the same day, hence I would prefer highlighting the relevant shift but assume this cant be included in an IF function?
okay with the additional columns that works. Out of interest how are you getting the yellow highlight to come up?
I'll post another question (another new questions etc)