With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, November 8, 2014
yogi_Conditionally Format Cells In Columns A and C and Columns B and D For Non-Matching Entries
which I tried to implement in the sheet referenced above.
I have 2 lists of values that I am trying to make sure that they match. Each list has 2 columns (Account number and Account Name) - both should match. I just want to make sure that all of the values in Columns A/B are in Columns C/D. . The list in Columns C/D will contain additional values as it contains subtotal fields, but these can be ignored.
I am trying to compare the values in Columns A and C and output an indication if there are any values that are NOT in both columns. I want to do the same thing with Columns B and D.
As an example: Let's say in Column A there is a value of 4010, but this value is not in Column C because I accidentally entered it as 4011. I want those unique values to some how be highlighted so I can change them to get them to match.
Perhaps conditional formatting would be a better way to go about this. Any help would be greatly appreciated.