Hi there again!
I would like to ask if there is any way that I can make a conditional formatting formula changing my color font from being transparent. I made the font color of cells A1:A10 transparent by customizing the format with ;;;. But, if B2 has value, how can I bring back the font color of cells A1:A10 from being transparent.
Please help me on this.
Thank you very much!
I would like to ask if there is any way that I can make a conditional formatting formula changing my color font from being transparent. I made the font color of cells A1:A10 transparent by customizing the format with ;;;. But, if B2 has value, how can I bring back the font color of cells A1:A10 from being transparent.
Please help me on this.
Thank you very much!
Last edited: