How to change row formatting based on a single cell?
I am trying to create a list of design standards and have a drop down list in a column that associates each row to a different project type: Affordable, Market, Selling.
I'd like to be able to have the first row be a control that sets criteria for the rest of the sheet or a specific column. Thus if I select "affordable" in Row 1, then the rest of the items in not listed as "affordable under column "Project Types" are struck through. (as shown in the first screen shot).
At this moment I am only able to get a conditional rule that changes everything entered in the column.
Any help is appreciated?