Actually i've discovered a problem,
The code works with cells highlighted with a fill colour, but unfortunately doesn't work for cells which have a color due to a conditional format. Is there any way to modify the code so that it detects the conditionally formatted colour, and deletes that row instead?
Or if thats not possible, a button, that when pressed, automatically converts the conditionally formatted color to a fill color of the same color, if that makes sense. So if the cell is Red, due to a conditional format, a button is pressed, and it removes the conditional formatting but keeps the color as red - Then i could use the code as normal.
Just this final problem to solve then my spreadsheet is complete!
Please help!
Bookmarks