Colour Cell When Alternative Is Found

[Dazzawm]

I have sheet 5 with a list of numbers in column A & B. I need a macro please that whenever I write or paste a number in column AE on sheet1 that is on sheet 5 in column A then to colour the cell in AE.

So if I copy or paste NS606292 into column AE on sheet 1 there is a number next to it in column B - CIR25000P so NS606292 needs to be coloured on sheet 1. If I enter a number in AE on sheet 1 and it is not in column A on sheet 5 then don't colour. Hope I have explained ok. Thanks.

NS606292	CIR25000P
NS606087	CIR8000P
NS617852	CR10000S

 

[Dazzawm]

So what's the difference with my Conditional Formatting formula in post #2 ? Have you tried deleting an input in the AE column ? Does the macro behave as you wish ?
Instead, have a try with my CF only and see if it behaves smarter (this would be my level of AI though).

One main difference is I requested a macro and not a formula.

 

[rollis13]

Oh, that makes sense.