AlwaysLearning2018
Board Regular
- Joined
- Nov 23, 2018
- Messages
- 51
Hi everyone,
Question about conditional formatting. A have a dataset that is 6 columns of data, and I copy and paste the same 6 columns from a different data source right next to this, and then compare to see if there are differences. It works fine but where it is limited is that it is just looking for a 1 to 1 ratio where lets say I have an account 415A in one set and 1 account 415A in the other nothing would highlight for a unique value. I'm trying, in addition to spotting differences, make sure the data isn't flipped. Example would be I have account 404B matched with a quantity of 500 in one dataset along with account 415A matched with a quantity of 800. In the other dataset, if these are flipped, say 404B with quantity 800 and 415A with Quantity 500, I want that highlighted. Any suggestions? If this makes no sense, I'm sorry!!!
Question about conditional formatting. A have a dataset that is 6 columns of data, and I copy and paste the same 6 columns from a different data source right next to this, and then compare to see if there are differences. It works fine but where it is limited is that it is just looking for a 1 to 1 ratio where lets say I have an account 415A in one set and 1 account 415A in the other nothing would highlight for a unique value. I'm trying, in addition to spotting differences, make sure the data isn't flipped. Example would be I have account 404B matched with a quantity of 500 in one dataset along with account 415A matched with a quantity of 800. In the other dataset, if these are flipped, say 404B with quantity 800 and 415A with Quantity 500, I want that highlighted. Any suggestions? If this makes no sense, I'm sorry!!!
