Conditional formatting to change the color of one cell when another is not empty

Unsolved

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

Comments aren't archived yet

This post had 2 comments on Reddit. Comments for this period haven't been loaded into the archive yet.