Conditional Formatting

[PRodgers]

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?

[Charlize]

add a second conditional format.

Please Login or Register  to view this content.

and set this one to be white.

Charlize