Hey guys,

I'm rubbish at macros, I'd really appreciate someones help with a simple quick macro. I've got column B with values in, and column D with values in.

I'm trying to make a macro that clears the cell in column D, based on the column B cell being value X. and it would do this for all cells in the whole of both columns,

Can anyone help? I'd really appreciate it, I've been stuck for hours