Conditional formatting based on levels

[nemmi69]

So
1, 2, 3 etc. is a top level task
1.1, 2.1, 3.1 etc. is the next level down
1.1.1, 2.1.1, 3.1.1 etc. is the lowest level

How do I get the conditional formatting to colour as below?

 

[JamesCanale]

Use this formula to get the number of "."

=LEN(C25)-LEN(SUBSTITUTE(C25,".",""))

Use that in conditional formatting.

 

[nemmi69]

How do you apply that for each of the level/colours?

 

[JamesCanale]

for dark blue:

=LEN(C25)-LEN(SUBSTITUTE(C25,".",""))=0

for lighter blue:

=LEN(C25)-LEN(SUBSTITUTE(C25,".",""))=1

for still lighter blue:

=LEN(C25)-LEN(SUBSTITUTE(C25,".",""))=2

 

[JamesCanale]

MrExcelPlayground15.xlsx
	C	D
25	1	Thing
26	1.1	Subthing
27	1.2	Subthing
28	1.2.1	Double Subthing
29	2	Thing
30	2.1	Subthing
31	2.1.1	Double Subthing
Sheet29

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C25:D31	Expression	=LEN($C25)-LEN(SUBSTITUTE($C25,".",""))=2	text	NO
C25:D31	Expression	=LEN($C25)-LEN(SUBSTITUTE($C25,".",""))=1	text	NO
C25:D31	Expression	=LEN($C25)-LEN(SUBSTITUTE($C25,".",""))=0	text	NO

 

[nemmi69]

works great, thanks!