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…...Cells Product Family cells-java matthew.lo.housing September...A3’s value is 1. image.png (768 位元組) image.png (828 位元組) However...