hi cicihk

first the match function is giving the column numbre if Fail is found in the range. that number >0 will give result true if there is a fail in the range.

an if true if function give result "Fail"