Setting Validation rule on Data form Cells when there is a invalid data #error
Summary:
In Row formulas we are getting #error in cells. Need to suppress these values or color the cell. Tried different options, but not working
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tried:
IF Current Cell Value Equals Value #error then process cell with a color
IF Current Cell Value Equals Value 0% then process cell with a color
Tagged:
0