Hey everyone! I’m working on a Google Sheets project and need some help with conditional formatting. Here’s what I’m trying to do:
I want cell A2 to change color when A1 has any content.
Then, I want A2 to go back to normal when someone types something in it.
Is this doable? I’ve figured out the first part, but I’m stuck on how to make A2 lose its color when it gets filled. Any tips or tricks would be super helpful!
I’m pretty new to advanced spreadsheet stuff, so please explain it like I’m five. Thanks in advance for any advice you can give!
hey tom, try this: set A2’s formatting to check if A1 is filled, then add a higher priority rule that clears formatting when A2 isn’t empty. hope it works!
As someone who’s worked extensively with Google Sheets, I can tell you this is definitely doable! Here’s how I’d approach it:
For the first part, you’re on the right track. Use conditional formatting on A2 with a custom formula like =NOT(ISBLANK(A1)).
For the second part, you’ll need to add another conditional formatting rule to A2. This time, use the formula =NOT(ISBLANK(A2)). Make sure this rule has a higher priority than the first one.
The trick is in the order of these rules. The second rule (A2 not blank) should override the first rule (A1 has content).
I’ve used this method in project management sheets to highlight tasks needing attention. It’s a great way to visually track progress without manual updates. Hope this helps!
Conditional formatting in Google Sheets can accomplish what you want. Start by selecting cell A2 and opening the Format > Conditional formatting menu. Define a rule with the formula =NOT(ISBLANK(A1)) to set a desired background color when A1 has content. Next, create another rule for A2 using the formula =NOT(ISBLANK(A2)) to revert the cell to its default appearance when it is filled. Ensure the rule for A2 being non-empty is prioritized over the one based on A1. This setup allows A2 to update automatically based on its own content and that of A1.