Was calculated with vba to realize the drop-down to select E column input, E column after keyin the style of the red background requirements, if is produced by selecting the D column and the value of the don't need the background color to become red

CodePudding user response:

That is E column by default for the red background, if D column fill in by VBA, filled with a single line of code by the way the cell background color set to white bai,