Conditional validation not enforcing rules
Asked By
130 points
N/A
Posted on - 12/26/2014
Why does the conditional validation rule fail to restrict the rule set? I need to compare the current cell against the value returned by a function. I use this formula to prevent a person using the workbook from entering a date that falls on a weekend:” = (WEEKDAY(C4)<>2, WEEKDAY(C4)<>7)”. If C4 is the cell that containthe validation rule, What prevents the formula from forcing C4 to adhere to both restrictions?