Excel Aid Required

Job ID: 37671522

Budget: $250 – $750 USD

I want on sheet 4 the user will select which LVDS wants to use as the primary in column C if the answer is no then in ALL LVDS sheet add X to the corresponding LUR and color with the same color of the LVDS color.
If the C is Y then select which LVDS in column D they should not be the same as column B and add X in ALL LVDS sheet, but don't color.