I have a workbook that gives visualisation of staff Annual Leave. i want to be able to have their name added to the first cell of their A/L where a block is coloured in depending onFormula:=AND($C3<=I$2,$D3>=I$2)
I have got a formula that works:but I was wondering if there was a more efficient way of this working rather than having this formula in (almost) every cell in the worksheetFormula:=IF(AND($C3=I$2,$D3>I$2,$F3>14),$B3,"")
Bookmarks