How can I Conditional format cells with a formula in them instead of a value.
I am using the Mid function to extract a text string to a column, then I
want to use Conditional formatting to highlight the cells that matches any
cell in another range of cells. Any ideas?