Ok I've tried that, it seems to work fine so long as C5 = 'Factory Load', the moment C5 is change to 'CFS Loading', that's when it falls down.

Basically I only need the change C5 to 'CFS Loading' when selecting either Gdynia or Hamburg to New Your or Los Angeles, the rest don't need it, I didn't know how to just have them selectable so was trying to force C5 to 'Factory Load' for the rest, which is why they work but then fails when either Gdynia or Hamburg is selected.

If it helps below is what Im looking at, think on them as conditional drop downs

All the other lanes can be set same as the first one ie C5 is Factory Load

C3 =
Ocean_EU_to_US



C4 =
Genoa to New York



C5 =
Factory Load








C3 =
Ocean_EU_to_US



C4 =
Genoa/La Spezia to Los Angeles



C5 =
Factory Load








C3 =
Ocean_EU_to_US



C4 =
Gdynia to New York



C5 =
Factory Load or CFS Loading








C3 =
Ocean_EU_to_US



C4 =
Gdynia to Los Angeles



C5 =
Factory Load or CFS Loading








C3 =
Ocean_EU_to_US



C4 =
Hamburg to New York



C5 =
Factory Load or CFS Loading








C3 =
Ocean_EU_to_US



C4 =
Hamburg to Los Angeles



C5 =
Factory Load or CFS Loading








C3 =
Ocean_EU_to_US



C4 =
FXT/SOU to New York



C5 =
Factory Load








C3 =
Ocean_EU_to_US



C4 =
FXT/SOU to Los Angeles



C5 =
Factory Load