Dear Excel experts,

I have two cells (G91,G100) on "Sheet2" which are conditionally formatted (highlighting background RGB(201, 243, 240)) when they are empty.
So, when I type text in cell G91, the highlighted background disappears, and when I type no text in formatted cell G100, the highlight still remains in cell G100. However, I do not wish to print the highlighted background in empty cell G100.
The highlights are only used to edit in screen view, so they should not be printed.

I found some code online and altered it, but it does not seem to work. Any suggestions or alternative code on how to make it work?

Please Login or Register  to view this content.