Pregunta:
Optimizar macro para combinar filas
Option Explicit Public Sub ConsolidarRapido() Dim ws As Worksheet, wsOut As Worksheet Dim rng As Range, data As Variant Dim dict As Object, k As Variant, itm As Variant Dim i As Long, nCols As Long, nOut As Long Dim outArr() As Variant '=== CONFIGURA...
Pregunta:
Cambiar de color una fila completa al poner una letra
Si no deseas hacerlo con macro, entonces hazlo así: =$W2="X" Esto con formato condicional, seleccionando la opción "que contenga" No olvides seleccionar o indicar el rango donde deseas que de cumpla esta condición.