Hi,
Empty cell validation only applicable for row has a value.Here empty row has been checked,but i can’t able to change row background color to white (mention in the code).
Please help me how to change red color to white color for entire row, this scenario only applicable for empty row. It’s possible to do that?any way to remove highlight red color.
In this scenario, the user has type some text in all columns A1,A2,A3 and remove the text from A2,A3 columns at row 2, If i remove the last text from cell A1 then row should be changed to white color due to empty row.
If you are only looking to allow to add an empty value you can return any numeric value when user leaves the cell blank, here’s how I do it https://jsfiddle.net/pk7Lg7yw/ (I am using beforeValidate hook)