I currently have conditional formatting set to fill in cells in columns B:C with the red pattern. Once either YES or NO is chosen from the drop-down, that red pattern goes away. What I'm wanting now is to format the corresponding rows in Columns D:P to fill in with that same red pattern IF the corresponding cell to the left (B:C) is marked YES. Essentially- the cells are to fill in with the 'red pattern' when the user needs to fill in a value. Hence, the cells in B:C fill in red until either YES or NO is chosen, and I want the cells in D:P to fill in IF the cell to the left if marked YES, because if it's marked YES that means there is an 'impact' and the associate needs to explain the impact in D:P.
In the example, I would want Row 39 D:P, Row 42 D:P and Row 43 D:P all to have the 'red pattern' in their cells because the column to the left of them was marked 'YES'.
Is there a conditional formatting rule I can use for cells D:P that will format them ONLY if the cell to the left (B:C) is marked YES.
2022-03-30_14-22-24.jpg
Bookmarks