I have conditional formatting set up now but it is much to slow, I need something more efficient.
Here is the formula I have: =OR(AND(F4="", $E4="Finished Good"), AND(F4="",$E4="Device Identifier"))
This is applied to D4:CG2700
I need a sub in VBA to loop through the rows and if column E equals either finished good or device identifier AND the cell in question is blank, turn the background yellow.
Is there a simple solution? I think I'm over complicating as I can't get it to work.
Here is the formula I have: =OR(AND(F4="", $E4="Finished Good"), AND(F4="",$E4="Device Identifier"))
This is applied to D4:CG2700
I need a sub in VBA to loop through the rows and if column E equals either finished good or device identifier AND the cell in question is blank, turn the background yellow.
Is there a simple solution? I think I'm over complicating as I can't get it to work.