R
RayD
Hello everyone,
Before I get into the meat and potatoes of this macro, column "H"
will have a red (5) background put there by conditional formatting.
So really not sure if this approach will work, but here goes.
Check range Sheet1 (H5:H1968) for cell background = Red (5)
if TRUE do nothing.
If cell background = White (46) (or default I think), then DELETE
each cell contents in Sheet1 column (I5:I1968) that condition applies
too. -Thanks
Any help would be appreciated.
Before I get into the meat and potatoes of this macro, column "H"
will have a red (5) background put there by conditional formatting.
So really not sure if this approach will work, but here goes.
Check range Sheet1 (H5:H1968) for cell background = Red (5)
if TRUE do nothing.
If cell background = White (46) (or default I think), then DELETE
each cell contents in Sheet1 column (I5:I1968) that condition applies
too. -Thanks
Any help would be appreciated.