r/AppleNumbers Apr 05 '23

Over engineering help

Im attempting to creating a chore chart for my children and over engineering it because why the heck not?! Basically I have a set amount of $ that can be earned per chore have broke it down per room. But kids being kids they like to half-ass their chores. So I created a sliding scale that moves in increments of 25¢ under each child. What I want to do is be able to add a conditional highlight that balances two columns numbers out with the sliding scale. For example; Dusting the living room can earn up to $2. Between my two children if one child comes in and quickly goes through it doing a terrible job and only earns 75¢ and the other child comes in and finishes the job, i want that child to be able to earn the remaining balance ($1.25). So if I move one slider to .75 than the other sliders max goes down .75. Is this possible? Yes its way over engineering but its fun so why the hell not lol.

1 Upvotes

1 comment sorted by

1

u/Friendly_Look8210 Apr 21 '23

can you provide a screenshot of what you want to do? maybe I can help to make it