ScottTemple
Board Regular
- Joined
- Dec 28, 2023
- Messages
- 103
- Office Version
- 365
- Platform
- Windows
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | L | |||
1 | Work Order | Coil # | Coil Wt | Building CF Formula | ||||||
2 | ||||||||||
3 | 543051 | 1A1-1 | 317 | FALSE | 0 | 0 | 0 | |||
4 | 543518 | 31 | 251 | FALSE | 1 | 0 | 0 | |||
5 | 543518 | 29 | 304 | FALSE | 1 | 0 | 0 | |||
6 | 543454 | 35 | 308 | FALSE | 0 | 1 | 0 | |||
7 | 550053 | 35 | 342 | TRUE | 1 | 1 | 1 | |||
8 | 550053 | 35 | 342 | TRUE | 1 | 1 | 1 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I3:I8 | I3 | =SUM((--(SUM(--($E3=$E$3:$E$8))>1)) + (--(SUM(--($F3=$F$3:$F$8))>1)) + (--(SUM(--($G3=$G$3:$G$8))>1)))>1 |
J3:J8 | J3 | =(--(SUM(--($E3=$E$3:$E$8))>1)) |
K3:K8 | K3 | =(--(SUM(--($F3=$F$3:$F$8))>1)) |
L3:L8 | L3 | =(--(SUM(--($G3=$G$3:$G$8))>1)) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
E3:G13 | Expression | =SUM((--(SUM(--($E3=$E$3:$E$8))>1)) + (--(SUM(--($F3=$F$3:$F$8))>1)) + (--(SUM(--($G3=$G$3:$G$8))>1)))>1 | text | NO |
No worries. Good luck in the new direction.Sorry about not replying back sooner Awoohaw, I was away from work the past couple of weeks. I want to thank you for your assistance on this topic, but I think I'm going to pivot in a different direction as some of our data sheets will be changing in the near future.