I have created a sample Excel file to reproduce the issue.
test2.Zip (9.6 KB)
In the Excel file, I added a conditional formatting to change A1 and B1 to white text color when A3’s value is 1.
image.png (768 位元組)
imag…...zip (9.6 KB) In the Excel file, I...thanks. John.He September 3, 2025, 7:21am 5 @matthew.lo.housing By...