Hi

I'm guessing the solution to my question will be VBA code so have enteerd it on this forum (hopefully it's the right place).

Can someone please tell me how I can clear the contents of one cell on a row dependent on a specific value being entered in another cell on the same row. Example:

Value in C1 is "Yes". If a date is entered in to cell M1 the value of C1 should be cleared.

Thanks.