Conditional formatting to change the color of one cell when another is not empty
As the title suggests, I'm trying to make it so that when I put any text into one cell than 2 others will turn red. So, for instance, if I type in E2, I want C2 and D2 to to turn red, and I want this rule to apply to all cells from E2 to E77 (and C2/D2 to C77/D77 respectively). Anyone have a formula that will do that?
Posted May 29, 2025, 5:52 PM UTC
12