Hi,

I'm trying to set a conditional formatting to compare two columns of values (including numbers and letters) and flag any cells on the righthand column that do not match. I'm doing this very simply by using the formula "=A1<>B1". However, this does not differentiate between one cell being '0' and the other being blank. Is there a way to do this?

Thanks,
Jamie