In he attached file I tried to color format visible cells as a result of an Auto Filter.
I managed to color the visible cells BUT upon filtering again I thought I should clear the color format from the previous filtered cells.
As you will see from the code I tried to begin with clearing column A but it seems that the invisible cells (the hidden) are not cleared.
If you filter by A and run the macro 4 "A" cells will get a green background.
If you will, now, filter by "B" - the "B" cells will now get their green background, BUT the "A" cells remain green which is incorrect.
Will you be so kind to correct/alter my code.