Conditionally Formatting Children

Art Schneiderheinze
edited 12/09/19 in Smartsheet Basics

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.

FOR EXAMPLE

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?

Comments