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…...pdf", saveOptions); Test with Simplified Data : Create...7:21am 5 @matthew.lo.housing By testing with sample files and code...