View original (French)

How to delete cells by color without VBA

stagiaire25 Posted messages 2 Status Member -  
Raymond PENTIER Posted messages 58229 Registration date   Status Contributor 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 answers

  1.
    via55 Posted messages 14395 Registration date   Status Member Last intervention   2 759
     
    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
  2. stagiaire25 Posted messages 2 Status Member
     
    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
    1. via55 Posted messages 14395 Registration date   Status Member Last intervention   2 759
       
      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
  3. ccm81 Posted messages 11033 Status Member 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
  4. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     
    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