Im looking to do a job list in excel similar to the below and was hoping to be able to filter it by category and/or priority. but how do I get it to keep the sub tasks aligned with the task without duplicating the priority numbers and task for every subtask.
I feel like I could conditional format font to white if cell is = to the one above it (although would have have a trickier one for priority.) but then I would have to retype it for everything. is there some sort of easier solution?
I feel like I could conditional format font to white if cell is = to the one above it (although would have have a trickier one for priority.) but then I would have to retype it for everything. is there some sort of easier solution?
Category | Priority | Task | Sub Task |
House | 1 | Clean | Sweep Floors |
Wash Dishes | |||
House | 2 | Install bench | assemble items |
screw bench top on | |||
seal benchtop to wall | |||
Garden | 1 | Plant Trees | Plant natives |
plant fruit trees | |||
fertilise | |||
water | |||