Forum Discussion
Conditional Formatting
Hi all, I’m not the sharpest at using excel but was wondering if somebody could help me with a formula so that i dont have to ‘whiten’ every required box when the job numbers on the left begin...
This will do it. You need an array constant and a simple formula for the rule:
Prefix - defined name
={53;54;61;62;71;72}
Conditional Formatting Formula
=AND(XOR(LEFT($B2,2)*1=Prefix),C$1="Required")