Conditionally Formatting Children
I am using Conditional Formatting to change the background color of a row based on the value of a cell in that row. I want to visually distinguish courses on a course development list belonging to certain colleges.
If College="UC", color background yellow.
If College="PS", color background light blue.
I am modifying the structure now because for some courses there is a request for more than one modality (blended and online, versus just blended). I want to set up the course row with more than one modality to have each modality be a child.
If the parent is a course in UGC (College="UC"), the parent is still the same yellow, but the children are all a different shade of yellow.
Can you set up conditionally formatting not only based on the value of a cell but also on whether or not it is a child or parent?