Forum Discussion
Conditional formatting
- Oct 21, 2021
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.
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.