Column Validation

Posted by: stylish16 on 8 September 2017, 2:52 pm EST

  • Posted 8 September 2017, 2:52 pm EST

    Hello all,

    I have three columns, Out of Which

    1st Column : Total Value

    2nd Column : Some Value

    3rd Column : Difference between 1st and 2nd column.

    If user has entered some wrong value in 3rd column, third column must change colour or  do some popup to display to the user that he has entered wrong value.

    How can i achieve this?

    Thanks.

  • Replied 8 September 2017, 2:52 pm EST

    it sounds like your third column should be a formula cell and your users shouldn't be adding data to it, if you want to change the Backcolor depending on its value you can catch the CellChanged event and set it in there.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels