I am trying to filter a number of colour cells and eliminate those with out colour. How do i achieve it?
You could create a vba macro and run it from in process:
excel - VBA code to delete cells that contain a certain fill color? - Stack Overflow
Here is an idea
basically instead check that the cell has any value, just check if its empty and instead fill with colour just delete it
if any questions i would help you
Refer to this thread, you may get some idea.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.