Excel条件格式公式求助：V2单元格高亮规则异常问题

Got it, let's get this sorted out. The problem with your current formula is that it doesn't account for whether V2 has content or not—let's fix that step by step.

What's Wrong with the Existing Formula #

Your current formula =IF(ISBLANK($U2),"",Q2>60) only checks two conditions:

• If U2 isn't blank
• If Q2 is greater than 60

It completely ignores whether V2 is empty or not. That's why the red formatting sticks around even when you type something into V2—those first two conditions are still true, so the rule triggers regardless of V2's content.

The Correct Formula #

You need a rule that verifies all three required conditions at the same time. Use this formula instead:

=AND(NOT(ISBLANK($U2)), ISBLANK($V2), $Q2>60)

Let's break down each part:

• NOT(ISBLANK($U2)): Ensures U2 is not empty
• ISBLANK($V2): Ensures V2 is empty
• $Q2>60: Checks that Q2 is greater than 60
• AND(...): Makes sure all three conditions are true before applying the red formatting

How to Update Your Rule #

Follow these steps to apply the fix:

1. Select the range of cells in column V where you want this rule to work (e.g., V2:V1000)
2. Go to the Home tab → click Conditional Formatting → select Manage Rules
3. Find your existing rule, click Edit Rule
4. Replace the old formula with the one above
5. Double-check that the formatting is set to fill the cell red
6. Click OK to save the changes

Now, when you type content into V2, the ISBLANK($V2) condition will fail, so the entire rule won't trigger—and the red formatting will disappear automatically, just like you need.

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