View original (French)

How to delete cells by color without VBA

stagiaire25 Posted messages 2 Status Membre -  
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   -
Hello,

I am not knowledgeable in computer science; I know how to use Excel but not VBA. All the solutions I found to delete red cells (thanks to conditional formatting) use VBA, but I don't know how to use it.

Is there a direct solution in Excel?

Thank you in advance.

4 réponses

Réponse 1 / 4
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

Try to apply a filter based on the color red
Only these lines will display; select them and delete

Cddlmnt

--
"Imagination is more important than knowledge." A. Einstein
0
Réponse 2 / 4
stagiaire25 Posted messages 2 Status Membre
 
I tried, but the filter cannot be applied because the merged cells are not of the same size; I think I will have to select them myself!
0
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Merged cells are a nightmare for applying filters, formulas, and macros
Avoid them as much as possible (in 90% of cases they are unnecessary)
0
Réponse 3 / 4
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello

If it's a big project, this might be a good opportunity for you to get into macros; this one shouldn't be very complicated, either to write or to use.

Best regards.
0
Réponse 4 / 4
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
No.

Besides, generally we do not delete cells; we simply clear their contents.
If the cell coloring was done using conditional formatting, a solution is possible; but if it's manual coloring, there's nothing to be done, as the color is not a data but a format, and no formula can manipulate formats.

--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
0