Formatting strings of text within a cell

  • I have 2 cells of data, which I wish to compare. To date, just using conditional formatting to highlight whether the cell total contents are different between these cells has been sufficient. Now I've been asked to show only the different strings within the cells. I know this isn't possible within formula, but was wondering if VB could do this. Any idea if it's possible, and if so, how to do it?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!