Google Drive电子表格多单元格条件格式配置问询：实现基于单元格内容的动态着色与去色

Since you already have the first part working (A2 gets colored when A1 has content), we just need to adjust that rule to only apply when A2 is empty, plus an optional safeguard to ensure the color is removed once A2 is filled. Here's the step-by-step breakdown:

Step 1: Modify your existing conditional formatting rule #

1. Open your Google Sheet and select cell A2.
2. Navigate to Format > Conditional formatting to open the sidebar.
3. Locate the existing rule that colors A2 when A1 has content, then click the pencil icon to edit it.
4. Change the "Format cells if" condition to Custom formula is.
5. Replace the current formula with this:

   =AND(NOT(ISBLANK(A1)), ISBLANK(A2))
   

   This formula translates to: "Apply the fill color only if A1 is not empty AND A2 is empty."
6. Keep your desired fill color in the formatting style section, then click Done.

Step 2 (Optional but recommended): Add a rule to clear the color when A2 is filled #

To eliminate any edge cases where other rules might interfere, add a second rule that explicitly removes the fill once A2 has content:

1. In the conditional formatting sidebar, click Add another rule.
2. Set the "Apply to range" to A2.
3. Choose Custom formula is for the condition, then enter:

   =NOT(ISBLANK(A2))
   

4. Under "Formatting style", set the fill color to None (or match your sheet's default background color).
5. Drag this new rule to the top of the rule list—rules are applied top-to-bottom, so this one will override the coloring rule when A2 is filled.
6. Click Done.

That's all! Now:

• When A1 has content and A2 is empty → A2 gets your chosen fill color.
• As soon as you type anything into A2 → the fill color is immediately removed.

内容的提问来源于stack exchange，提问作者NoFace