Jun 23 2022 06:08 AM
Hi peoples
As i am sure this is the case for most people at work, you get half way through one task before another task presents itself and then we prioritize. I am trying to create a spreadsheet for work where i can keep tabs on where i am on multiple projects at the same time. So far, i can use the formatting functions with a tick box so that as i complete a task i can tick the box. Once all tasks for a client have been ticked i have one tick box at the very end of the row that i have used the 'TRUE' function in a hidden cell to highlight the entire row in a green colour making it apparent that all tasks are complete. however, when i go to copy this row to create subsequent rows, the final 'COMPLETE' tick box retains the same cell value as the previous one. This is becoming infuriating as i try different ways to get this done... HELP!!!!!!
Jun 23 2022 07:47 AM - edited Jun 23 2022 07:48 AM
@thombell100 I would skip the check boxes and just use "x". The attached example may shed a light on how you want to conditionally format this based on "x".
Jun 23 2022 07:59 AM
Jun 23 2022 08:12 AM
@thombell100 Not a superstar, just not fond of these fancy buttons and check boxes. They need Control and other settings like cell links to determine which check box is checked or not. An "x" or 1 or 0 is much easier to work with. Just a personal opinion though.
Jun 23 2022 08:21 AM