jeran042
Registered User.
- Local time
- Today, 10:48
- Joined
- Jun 26, 2017
- Messages
- 127
I need conditional formatting to take 3 arguments:
1 - Greater than or equal to 5 - form control txt_Percent
2 - Less than or equal to -5 - form control - txt_NPercent
3 - Greater than 5000 - form control - txt_Dollar
Here is what I have so far:
Im sure there is a better way to do this, and any suggestions will help,
1 - Greater than or equal to 5 - form control txt_Percent
2 - Less than or equal to -5 - form control - txt_NPercent
3 - Greater than 5000 - form control - txt_Dollar
Here is what I have so far:
Code:
([txt_PC_Due]>=[txt_Percent] Or [txt_PC_Due]>=-[txt_NPercent]) And [txt_Var_Due]>=[txt_Dollar]
Im sure there is a better way to do this, and any suggestions will help,