Status Change RYG for Pass or Fail
I have a sheet with 20 different [Pass Fail 1], [Pass Fail 2], [Pass Fail 3], etc.. columns that if any Fail I would like the status RYG to turn Red. Then if all Pass to be Green. I have never created a formula that has a range of columns I want it to validate as a whole. Any suggestions?
Help Article Resources
Check out the Formula Handbook template!