Forum Discussion
Conditional formatting
PeterSchmeits so I started down 1 path and got it to work but then thought of another option that is cleaner and easier. In BOTH cases I add an "x" or "y" to the cells that you manually highlighted (which you should remove that manual color). I used x and y because you had 2 colors and in theory could have multiple conditional formats to color differently accordingly but that gets tricky when you have both in the same chapter/subchapter. The 2 versions then:
a) split the chapter, subchapter, ... names into their own columns and then I created a formula
b) I added a column that 'redefined' the chapter, subchapter, etc... into a standard table of contents style: 1.1.a.1, 1.1.a.2, etc... It doesn't matter letters, numbers, roman numerals, etc... as long as all the corresponding sub-sections start with the parent id. (NOTE: you have 1 issue because you have chapter 5 with subsection 1-11 and then define a chapter 5.1 with additional subsections. So maybe I should have use 5.0.1 for the first group?)
See attached files and the conditional formatting inside each.
Thank you for your reaction. I submit a sample sheet containing mock information. I started using colours for visualisation, but if text (for instance an X) is a better way to indicate that in that month we will work on that item, I am fine with that.
Thanks again. Hope you can do some magic
PeterSchmeits so I started down 1 path and got it to work but then thought of another option that is cleaner and easier. In BOTH cases I add an "x" or "y" to the cells that you manually highlighted (which you should remove that manual color). I used x and y because you had 2 colors and in theory could have multiple conditional formats to color differently accordingly but that gets tricky when you have both in the same chapter/subchapter. The 2 versions then:
a) split the chapter, subchapter, ... names into their own columns and then I created a formula
b) I added a column that 'redefined' the chapter, subchapter, etc... into a standard table of contents style: 1.1.a.1, 1.1.a.2, etc... It doesn't matter letters, numbers, roman numerals, etc... as long as all the corresponding sub-sections start with the parent id. (NOTE: you have 1 issue because you have chapter 5 with subsection 1-11 and then define a chapter 5.1 with additional subsections. So maybe I should have use 5.0.1 for the first group?)
See attached files and the conditional formatting inside each.
- mtarler, thank you so much for this. I will have to do some shuffling, but this will work!
