Data validation

[dalbega]

Hello excel gurus. I have struggled with datavalidation. I am preparing a spreadsheet for a serving and credit scheme. I am preparing a spreadsheet with the following layout in cell C5 to G5: Person, date, muamala (saving, credit, loan, repayment), and amount. I want to use datadatavalidation to restrict entry of data such that:
- It is impossible for a person to take a loan before finishing a previous loan
- It is impossible for a person to take a loan which is greater than 3*savings.

I know I cannot have multiple datavalidation in 1 cell. My plan, unless you advise me otherwise, is to have one formula for the two conditions, and the following error message when someone enters data against the two conditions: Outstanding loan/incorrect loan amount.


​I hope I am clear. I look forward to your help

 

[Macropod]

Cross-posted at: Data validation

Please read Mr Excel's policy on Cross-Posting in rule #13 : Forum Rules

 

[dalbega]

Cross-posted at: Data validation

Please read Mr Excel's policy on Cross-Posting in rule #13 : Forum Rules

Thanks.

 

[arthurbr]

Also cross posted at Data validation | Chandoo.org Excel Forums - Become Awesome in Excel under another username....