I am using a simple conditional formatting rule that highlights specific cells that are blank in yellow as below
=ISBLANK(C1)
I want the cell to go back to white when i user clicks on the cell to add data, but if the cell is left blank keep it yellow.
Anyone help me with this, can i use conditional formatting for this?
Bookmarks