I have a workbook with 5 sheets in it, one being a holiday rota sheet and one a total sheet.
When I note a holiday request on the "holiday sheet" it is marked by a particular colour depending on the holiday type.
I am hoping to find a way of automatically copying the cells colour in the "holiday sheet" onto the "Total Sheet".