G
Guest
hi, I am trying to find if record exists for values met in 2 different
columns, for use in a conditional format.
info have is:
=INDEX(ROW($AQ$1144:$AQ$1228),MATCH(TRUE,$AQ$1144:$AQ$1228=$AQ11,0))>ROW($A$1144)
not sure how got this to work in Cond. Format since (for a TRUE), when
testing in an external cell get a VALUE error; but, want to compare to
another column for OR( values, e.g.:
=AND(
INDEX(ROW($AQ$1144:$AQ$1228),MATCH(TRUE,$AQ$1144:$AQ$1228=$AQ11,0)),
OR(AB11="ab',AB11="ac"))
oh yea: thanks.
columns, for use in a conditional format.
info have is:
=INDEX(ROW($AQ$1144:$AQ$1228),MATCH(TRUE,$AQ$1144:$AQ$1228=$AQ11,0))>ROW($A$1144)
not sure how got this to work in Cond. Format since (for a TRUE), when
testing in an external cell get a VALUE error; but, want to compare to
another column for OR( values, e.g.:
=AND(
INDEX(ROW($AQ$1144:$AQ$1228),MATCH(TRUE,$AQ$1144:$AQ$1228=$AQ11,0)),
OR(AB11="ab',AB11="ac"))
oh yea: thanks.