Hi,

My understanding is that conditional formatting doesn't work across worksheets. Therefore what I would like to do is create a Macro to do the following:

If a number (e.g. 12345) is typed in column A on worksheet A and it is the same as a number already in column B on worksheet B, then that cell in worksheet A turns Blue.

Is this doable?

Thanks for your help.