Dear fellow Excel users
I'm trying to do conditional formating on a set of data. I want the background of the cells to reflect which cells belong together.
In the above example I want to switch between having a background colour and no background colour everytime the sum adds to zero.
The purpuse is to show which registrations are connected visually.
Any ideas? I'm trying match with indirect and row numbers based on the sum, but I'm still not getting quit getting the excact idea how to solve this.
Best regards
I'm trying to do conditional formating on a set of data. I want the background of the cells to reflect which cells belong together.
In the above example I want to switch between having a background colour and no background colour everytime the sum adds to zero.
The purpuse is to show which registrations are connected visually.
Any ideas? I'm trying match with indirect and row numbers based on the sum, but I'm still not getting quit getting the excact idea how to solve this.
Best regards