In column A I have several contiguous rows with similar formulas in the cells that return various text strings as the result of the formulas. In column B I have typed in a list of the text strings I expect to appear in column A as a result of the formulas in Column A. I would like to flag any discrepancies that may exist, preferably by conditional formatting that would highlight in red any cell in column A that does not match its corresponding (same row) cell in column B. The formulas I have tried to use to make the comparison will not recognize the text value RESULTS of the formulas in column A to compare with column B. The formulas all want to compare the text of the FORMULAS in column A with the text in column B, which, of course, will not match. How do I get a cell reference in a formula to read the text result of the formula in the cell being referenced instead of reading the text of the formula itself?