Code to colour in cell when criteria not met

[Dazzawm]

Hi, I need a code to look at the data in column AB and then look at column AC and colour in the cells if the criteria is not met.

Criteria:-

If AB has the data starting with A then the data in AC must also start with A, if the data in AB starts with either N or J then the data in AC must start with N and finally if the data in AB starts with V then the data in AC must start with S. So like I say if the criteria is not met then I would like the cells highlighted.

It has 35000 rows of data to look at so a code would be better than an If/And type formula. Thanks.

 

[mirabeau]

Your requests quoted in Post#7 say that for cells that do not meet your criteria you want them left alone and you want them highlighted, presumably at the same time.

Your latest post does not clarify.

So what's a contributor like me to do? Not worry about it, of course!

 

[Dazzawm]

I asked for the code to look at the data in AB and look for any cells that start with A, J, N & V then look to see if the adjacent cell in column AC meets the criteria set above if not highlight the cells, which it is doing - fine. I want the code to ignore any cells in column AB that start with any other data other than the 4 letters as above. I cant put it any clearer than that surely!