Good morning,
I have a spread sheet which easily could go to 300 lines of information. It used data from two different systems and compares them.
Using Conditional Formatting I can determine which piece from each system does not match (in the sample it is column B and column I). This only works to a degree. As you can see in the sample B4 and B5 match so no formatting takes place.
The comparison should really lie between B and I and not within each column. The only way I can think of doing this is to run the Exact function. And this works...obviously.
However, I want it to be readily visible to the user. I would like to format the cells in B and I that do not match making them stand out rather than searching through the text created by the function.
I am thinking it may be a nested formula?
Anyways...I would appreciate any help I can get.
Bookmarks