Hi Matt,

See attached. I've used conditional formatting to apply one of three colours to the trigger cells - pale blue to for a value against a single trigger, yellow to indicate value against multiple triggers, red to indicate that a value should not be input against a given trigger (as there is already one for another portfolio).

Attached Files

Testbook.xls (31.5 KB, 9 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]