I got a big table where lots of cells/entries in Column D are red shaded (RGB 150, 54, 52).
Now I would like to achieve the following using a macro:
The macro is to loop thru all cells of Column D
If the macro hits a red shaded cell (RGB 150, 54, 52) the macro is to delete the cell above, e.g.
a red-shaded cell occurs in Cell D18. The cell contents of D17 is to be deleted.
Help is much appreciated. Thank you very much in advance.