Morning all
I was wondering if it is possible to count the number of (different on occasions) coloured cells within a spreadsheet.
ie... Our company has a spreadsheet with a calendar and operatives colour cells 'red' if on annual leave, 'yellow' if on Training etc..... I was wondering if it is possible to summarize these colours to calculate the total number of days people have had off over time.
Regards
Nathan
I was wondering if it is possible to count the number of (different on occasions) coloured cells within a spreadsheet.
ie... Our company has a spreadsheet with a calendar and operatives colour cells 'red' if on annual leave, 'yellow' if on Training etc..... I was wondering if it is possible to summarize these colours to calculate the total number of days people have had off over time.
Regards
Nathan