Thanks Pierre.
I had to tweak the formula slightly as I am needing the entire row formatted font red.
The only exception to this conditional format that still requires the red font is the parent task 900.90. As you can see it is 6 characters. Tweaking the formula slightly I was able to get the correct formatting.![]()
=LEN($C5)=5
Thanks again!![]()
=LEN($C5)<=6
Bookmarks