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…...to change A1 and B1 to white text color when A3’s value is 1.... which have some text formatting (some text in bold in this sample)...