Conditional Formatting results in another column
Hello, I used Conditional Formatting to find values that were in column B but not column C. I now want to show these results (without the shading) of this formatting in column D. In this sample case that would be 3 items. Also, column B may vary up to 1000 different items. Is there a way to rewrite the “Applies to” in the Rules Manager to just the cells in column B that have data starting with B2? I must be using the wrong wording to explain this because I cannot find any solutions. Thank you.
|