Hi! I have an extensive timesheet which at the end of the month I have to save as for the next month (I can’t make a template as each month I add or remove new employees with several employment data that needs transferring to the next month). I colour the cells of the data I transferred to the payroll software. When I save it as for the next month , is there a simple way to “uncolour” the cells? I can’t select all and do a no fill as there are columns that need the fill. I hope I’m making sense! Awesome, clear content!
Hmm, I think I understand what you're asking. I'd probably have to look at it to really give you better advice, but you could apply some conditional formatting. There's a lot of ways you could do it. For instance, you could include a column which references the status of a transfer (with checkboxes or True/False). If you transferred an employee from the old sheet to the new sheet, you can check off the box in the cell for that row. Then set up conditional formatting rules for the appropriate fields to automatically remove colors when the box is unchecked, representing new employee data. Does that make sense?
Nice video and good explanation !
Thank you!
Hi! I have an extensive timesheet which at the end of the month I have to save as for the next month (I can’t make a template as each month I add or remove new employees with several employment data that needs transferring to the next month). I colour the cells of the data I transferred to the payroll software. When I save it as for the next month
, is there a simple way to “uncolour” the cells? I can’t select all and do a no fill as there are columns that need the fill. I hope I’m making sense! Awesome, clear content!
Hmm, I think I understand what you're asking. I'd probably have to look at it to really give you better advice, but you could apply some conditional formatting. There's a lot of ways you could do it. For instance, you could include a column which references the status of a transfer (with checkboxes or True/False). If you transferred an employee from the old sheet to the new sheet, you can check off the box in the cell for that row. Then set up conditional formatting rules for the appropriate fields to automatically remove colors when the box is unchecked, representing new employee data. Does that make sense?