Forum Discussion

Ahmad Syafiq Roslan's avatar
Ahmad Syafiq Roslan
Copper Contributor
Sep 20, 2018
Solved

Data validation

Hi all, can you tech me how to use data validation wisely. I know how to put validation max number on entry column. but can i do it on sum table? 1) exp : based on attachment file "capture...
  • Lorenzo Kim's avatar
    Sep 20, 2018
    Data validation can only be applied to data entered (not the resulting value in a cell, I think)..
    you can try Conditional formatting to check your result.
    HTH

Resources