Hi, I'm trying to build a formula that would take the content of a cell and
compare it to the value (yes or no), of a range of cells, then show the cell
reference (column/row#) if the cell reference does not meet the given
criteria. Ex....
if... Column A, Rows 3-15 contains the letter "B"
then... Columns "D and/or F" (rows 3-15) should contain "yes", However
if... any of the rows contains "no" in both columns (D & F), then show which
row..