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.
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks