I have worksheet with a query built in. I am trying to change the color of a cell if that cell does not match value in another cell. I could use conditional formatting but since the other cell is connected to a query, table rows could shift.
Sheet1 B3 should change to red fill if it does not match D3 in Sheet2. (I just realized my code did not identify a sheet ).
It is a change event so every time cell B3 changes I want desired output.