I’m trying to figure out how to apply conditional formatting to highlight an entire row while keeping certain cells with different colors. My specific situation involves rows that contain the word “scheduled” - I want these rows to have a purple background throughout. However, there are two particular cells in each row that should maintain their own distinct colors instead of turning purple. One cell displays “not Submitted” and another shows “pending”, and I need these to stay as they were originally formatted. I’ve been using the “text contains exactly” conditional formatting rule for individual cells, but now I’m wondering if there’s a way to combine row-level formatting with cell-level exceptions. Is there some kind of formula or formatting technique that can highlight the whole row except for cells containing specific text values? I want to maintain my existing cell formatting rules while adding the row-level purple highlighting.