I have a script that works perfectly but I have some staff that will run the script even if a cell is red which was put in place to prevent missing data being sent out.