Cambio de color en varias celdas excel

Te dejo un código para colocarlo en un módulo. Ajusta el rango donde se van a reemplazar los colores de las celdas.

Sub reemplazaColor()
For Each cd In Range("A1:X36")
    If cd.Interior.Color = 65535 Then cd.Interior.Color = 255
Next cd
End Sub

I. Hola Compañero, no domino Excel en absoluto pero creo que la manera más sencilla de colorear cada celda de deseemos podría ser hacerlo bajo el criterio de una condición.

Si lo desea y dispone de tiempo podría ver unos tutoriales que tal vez sirvan, siento no poder ayudar mucho, y le ruego me disculpe por todas las molestias. Ánimo y suerte.

https://superuser-com.translate.goog/questions/1797929/how-to-change-a-cells-color-depending-on-the-value-of-the-cell-above-it-before-i?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://xlncad-com.translate.goog/replace-cell-color-using-the-find-and-replace-tool-in-excel/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

Botón de macro para cambio de color de celdas.

https://es.ccm.net/faq/10929-como-colorear-celdas-segun-una-condicion-en-excel 

Cambio de color en celda

https://www-wps-com.translate.goog/academy/how-to-change-cell-colors-in-excel-quick-tutorials-1864588/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://communityhub-sage-com.translate.goog/site_help/b/excel-tips-tricks-list/posts/how-to-change-the-fill-colour-in-multiple-cells?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://excel-tips-net.translate.goog/T002757_Changing_Cell_Colors.html?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://support-syncfusion-com.translate.goog/kb/article/1651/how-to-change-the-color-of-the-selected-range-of-cells-in-a-winforms-gridcontrol?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://stackoverflow-com.translate.goog/questions/72177151/script-to-find-all-colored-cells-in-a-range?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://stackoverflow-com.translate.goog/questions/73445965/selecting-cells-with-certain-colour-vba?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www-ablebits-com.translate.goog/office-addins-blog/sort-by-color-excel/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www-ablebits-com.translate.goog/docs/excel-select-cells-by/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://spreadsheeto-com.translate.goog/sum-by-color/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www.quora.com/How-can-I-get-the-range-of-cells-which-have-been-coloured-by-conditional-formatting

https://es.scribd.com/document/584454395/Como-disenar-Macro-para-colorear-filas-por-coincidencias-Visual-Basic-Todoexpertos-com 

https://www.mrexcel.com/board/threads/changing-color-of-a-selected-range-of-cells-using-a-macro.708936/ 

https://techcommunity-microsoft-com.translate.goog/t5/excel/how-do-i-make-excel-change-the-colour-of-a-cell-depending-on-a/m-p/100436?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc