Conditional Formatting to compare cell's value against anothers

[Orlando322]

Longtime lurker who couldn't figure out/find a solution to my problem.

For simplification, I have values in column A from A8:A16, but I only want to format A13:A16. I have the cooresponding values in which I want to compare A13:A16 in nonadjacent rows and columns

I want to look at A13 and if it doesn't equal V42 (its cooresponding value), I want it to be highlighted yellow... if A14 doesnt equal V43, highlight yellow.

I know I can go to each cell and do that individually, but I am wondering if there is a dynamic formula I can use so that I dont have to go into each cell and hardcode it.

The current formula that I'm using, which highlights both cells where the cooresponding cells are equal and not equal is: =AND((A13<>V42),(A14<>V43),(A15<>V44),(A16<>V45))....I need it to just highlight the cooresponding cells in which they are not equal, not the whole range if only one is not equal.

Hope this makes sense and thanks in advance

 

[theBardd]

You are right, in the OPs follow-up when he mentioned the non-contiguous range I missed the point about A13 comparing against V42, but A15 comparing against V43.