"Hi,
I am trying to write a script that will check specific columns and ensure it contains
two cells with *specific text A* AND two more cells with *specific text B* AND a cell with *specific text C* AND a cell with *specific text D*.
If all that is in the column, then set that columns cell 3 background colour grey, however if even one of the specific texts are missing then set that columns cell 3 background to red.
I am trying to write a script that will check specific columns and ensure it contains
two cells with *specific text A* AND two more cells with *specific text B* AND a cell with *specific text C* AND a cell with *specific text D*.
If all that is in the column, then set that columns cell 3 background colour grey, however if even one of the specific texts are missing then set that columns cell 3 background to red.