Share via

BUG: Excel conditional formatting

一 汪 1 Reputation point
2021-12-10T06:10:17.553+00:00

Excle version: 2111(14701.20226)

Conditional format does not run correctly

156544-bug.gif

download test excel file : test.xlsx

Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff
    2021-12-13T07:36:33.037+00:00

    Hi @一 汪 ,
    I found Excel cannot realized the table is increased.
    As a workaround, you can increase the table 1 first and then run the Conditional Formatting rules:
    157074-1.gif

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance, I'm glad to help you.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.