Código para colorear celdas numéricas

Tengo una hoja Excel y lo que busco es un código que me coloree las celdas con dos cifras iguales en cada celda como por ejemplo

3366, 5588, 1122, 8989, 5252

1 respuesta

Respuesta

I. Hola Jhon, en mi caso quisiera proponerle la función 'Contar Si', ya que es lo único que conozco.

https://www.youtube.com/watch?v=al5JLQWPsNw 

Aunque no soy usuario de Excel, quisiera facilitarle la información que vi sobre este proceso por si pudiese serle de alguna utilidad mientras le atiende una persona conocedora de primera mano.

Le ruego me disculpe todas las molestias y el tipo de respuesta, ánimo.


https://superuser.com/questions/846658/different-colors-for-different-consecutive-text-values-in-excel 

https://superuser.com/questions/564815/change-the-fill-color-of-a-cell-if-the-value-of-that-cell-equals-the-value-of-an 

https://superuser.com/questions/1074311/conditional-formatting-cell-value-equal-to-multiple-numbers  

https://stackoverflow.com/questions/20008632/excel-can-i-create-a-conditional-formula-based-on-the-color-of-a-cell 

https://www.youtube.com/watch?app=desktop&v=YAzK9vHa178&t=0s 

https://www.youtube.com/watch?v=0U6JDsiu5uY 

https://www.reddit.com/r/excel/comments/1ijt6kd/i_need_cells_to_change_color_when_they_contain/ 

https://www.mrexcel.com/board/threads/color-more-than-one-cell-on-the-same-row-when-a-cell-has-a-certain-numeric-value.547264/ 

https://www.reddit.com/r/excel/comments/1c4vhpe/any_way_to_set_multiple_colors_based_on_text_in_a/ 

https://www.youtube.com/watch?v=jDxuNe60_5c 

https://www.youtube.com/watch?v=zlIm8NugVKI 

https://www.youtube.com/watch?v=g3W-Yokdt6g 

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 

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas