3 ms·
> generate a constraint like `=MUST(W1!C:C<1337)`; then Excel would flag any rows where the calculation is false (≥1,337). I do exactly that double-checking in
by RecycledEle 3y ago
> generate a constraint like `=MUST(W1!C:C<1337)`; then Excel would flag any rows where the calculation is false (≥1,337).
I do exactly that double-checking in Excel with conditional formatting.
If I enter a blood pressure reading that is over 250 or under 35, the cell turns bright red.