I'm using a module that scans for certain patterns across thousand of rows.
If a pattern is found, the macro applies a cell background color = yellow to each record (columns A:X) .
For another activity, I now would like to use a formula to identify those records. For example:
=If(A1=Yellow,"Error","Ok") How can this be accomplished?